Issue#27: Tableau - YTD Totals and Total by Dimension Type

  • Hello All.  I have a two part question which If someone could be so kind to provide a solution, it would be a huge advancement for the work I'm trying to do in Tableau ( this would be a simple calculation in Excel ).  Below are the two points I need help with please:


    a)  A calculation that will bring me the Total for October YTD for the following years 2015 and 2014.  I think it may be necessary to have the option to select the month considered for YTD, in this case October.


    b) A calculation that will total differently based on the specific Dimensions.

    • The first dimension is an end of month total deposit balance;  (YTD Total should be the balance of October, not the sum of the 10 months). 
    • The second dimension is 'Sales' which DOES TOTAL all the months for the year.


    Below is the table (prepared in Excel) that I am trying to duplicate in Tableau.  I've also attached the excel file as a reference. 



    Thank you to all who can offer help!!!!

    0 Answers

    Sorry, your answer is too short !

  • Issue#28: Tableau - How to find Total till YTD minus 1 day

    I have to select YTD in the date filter mandatorily as i want to find total since the beginning of the current year But I want to find the total till YTD - 1. Can anyone assist. Regards,

  • Issue#20247: Tableau - Percent of total from value in Dimension

    Hi there, I have a large table of data that has the following structure - DateUser AttributeCount1/1/16Web Session501/1/16Purchase301/1/16Active1001/2/16Web Session501/2/16Purchase401/2/16Active90 I'm trying to create a calculation that displays % of total Active based on whether they had a web session or purchase. For example ideally the data would be structured like this in Tableau Date1/16/161/2/16Web Session50% (50/100)50% (50/100)Purchase30% (30/100)40% (40/100) I want to see what % of users are actually engaging on our website. I am able to do a full percent of total however it calculates it from all parts of the 'User Attribute' column whereas I want to calculate the percent of total from a value within that dimension. I've searched through the forums and haven't found a request that leverages data within a dimension. Any ideas?

  • Issue#373985: Qlik - Issue with Drilldown group dimension and YTD expression

    Hi All, I have a straight table with drilldown group as a dimension and YTD expressionwhenever user selecting any value which is not associated with current selections as per the qlik's associative nature all the filters getting cleared off.For ex:Year:2015Month:JuneAnd when user selecting any product which doesn't having sales in June,Month filter is getting cleared off.Is there any work around for this issue? Please suggest. Thanks,Ravi

  • Issue#482114: Tableau - 'Custom Total' for Percentage of Totals table calcuations

    Hi all, I'm trying to calculate the custom grand totals for TopN percentage values. users would like to see total percentage just for the TOP N. Tableau always shows this as 100%. Can anyone please help me and let me know if this is possible? .  I have attached the sample work sheet.I wold like to see the total percentage as  57%, not 100%. Appreciate your responses.  Thanks!

  • Issue#490149: Tableau - Adding Total columns and YTD vs. Last YTD columns in data table

    Hello, I am very new to Tableau and am trying to create a table of data in a very specific format.  I have sales by location, by month for the last few years.  I am wanting to add a yearly total column in that will show YTD for the current year and Yearly Total for prior years (would like this to show up where red arrows are in the picture).  I also am wanting to know how to add a calculation that will show year over year % change.  So for example, as my data is thru Feb. 2016, the sum for each row of Jan/Feb 2016 would be compared to the total from Jan./Feb. 2015 and the % difference calculated.  When I receive March data and add it, I would want the % change column to calculate the % change of Jan/Feb/Mar 2016 with Jan/Feb/Mar 2015 and so on.  Im trying to add this all the way at the end, where the green arrow is.  I have tried many different things and can't seem to get this to work, also I couldn't find an example of something similar being d

  • Issue#491380: Tableau - Percent of Total issue in a USA dashboard

    Hi, Attached workbook version: 9.1 Background:1. I created a superstore worksheet to show Sales as a Percent of Total across the United States.2. I duplicated the worksheet but filtered the States to only Arizona.3. I put these sheets in a dashboard. Problem:1. The actual Percent of Total value for Arizona is 1.54% But on the Arizona sheet it shows up as 100%. Note:- I know the reason as to why this is happening. It's because when filtered on Arizona, the Total Sales is the same as the Sales for Arizona location.- I want to know if there's a solution or a workaround to this problem.- My actual dashboard has Alaska and Hawaii but I couldn't find that in the Superstore database. Help will be much appreciated.Thanks in advance,Suraj.  

  • Issue#589911: Tableau - Custom Date showing values in Running Total for future months in YTD calculation

    Hello, I have a complex problem, which I am hoping someone can help me solve. I attached a workbook that uses the sample data set to help illustrate the problem. Here's the scenario: I am using a date, which has a fiscal year that starts in October. However, sometimes the data needs to be displayed by the actual calendar year, so I created a calculated date from the Order Date (called 'Order Date (Fiscal)'). I then need to create a YTD calculation based on the Order Date (Fiscal), but in order for the calculation to function properly with the fiscal year, I created 2 additional dates using a DATEADD function that add 3 months to the Order Date and TODAY(), titled Fiscal Date and Fiscal Date Today Respectively. The two YTD calculations are titled 2014 YTD Quantity and 2013 YTD Quantity. I have the two YTD calculations on a line graph over months of the year with a running_sum table calculation applied. My problem is this; the line graph extends through June, July, August,

  • Issue#736612: Tableau - Label showing total by day (when broken out by some dimension)

    This seems like an easy quesiton but I can't seem to figure out how to do the graph below have created a stacked area curve by dragging campaign name to the color mark. How can I show the grand total for each day? I.e. on May 24th I would show 33 (27+6) above the line... 

  • Issue#756636: Tableau - Grand Total Count dimension when there is no row

    Hello All, I am looking to count unique month days (Count Month Day) even if those months do not have existing rows for an employee so that the Grand total is 15 and not 3. Is this possible to do? Please find my sample workbook attached.  THanks!Jincy

  • Issue#943919: Tableau - Creating totals of dimension data using an SSAS Cube

    I am currently on 9.0 (no control there, thats what they have our server on)My data source is an SSAS Cube, which plays a distinct role in my problem here. What I am trying to create is a few charts that measure how many distinct users have accessed a part of the system each month. I have the data for when each user accesses the system in the cube. However, being a cube I cannot simply count them as I would in a sql database. So far I have found a way to create some charts (currently using a bar and a pie) that will give me size based on the number of distinct users. The problem is, each slice is the actual user and so it has an individual count of 1. I need to add to this, either as a mark or in a tooltip, the total of all of the users that make up that bar. Here is what I have done so far. I am completely open to doing it another way if it gets me what I need, as long as it works with my data source. 1. Create a calculated field (called mine Distinct Count) and then in

  • Issue#1008957: Tableau - Creating dimension from dynamic bins based on high,medium and low percent of total

    Hi Im using latest version of tableau. Im trying to achieve state segments as dimension based on percent of total desc dividing by high, medium and low equally.  Then state segments(high , medium & Low) by profits as show below. can i achieve this? Approach your  on this. Attached packaged workbook as well.    

  • Issue#1056444: Tableau - Grand Total Issue

    I need my grand total to sum while set to automatic to work properly for another field but cannot seem how to force it to sum the calculated field

  • Issue#20: Tableau - Aggregation issue

        Hello all, I just want to begin by saying how much this forum has saved my job! Thanks everyone! I am having an issue getting my values to aggregate properly. I have attached two pictures below to help explain:BEFOREAFTERThe problem is that when I remove a dimension, the values are not aggregating properly. Each Facility and Cost Center should have 1 App attached to it and taking away Summary Pay type should not aggregate those Apps. Once I take away Cost Center, then they should begin to aggregate. I can use MAX() but then it keeps the same value when I get rid of cost center and I would want that to be Summed. The end goal of this is to track Dollars/App By facility and able to drilldown to cost center, then summary pay type and another layer of fidelity that I may add in. Thanks!

  • Issue#98: Tableau - Percentage of Total

    How do I create the last 2 columns? NameItemsWeek 1Week 2Total% of Total% of Grand TotalJane Total4090130=130/130=130/210JaneBook2050=70/130=70/210Paper2040=60/130=60/210Mike Total6050110=110/110=110/210MikeComputer4030=70/110=70/210Lamp2020=40/110=40/210Grand Total90120210=210/210

  • Issue#556: Tableau - Multiple Data Source Filtering Using Different Dimension than Parameter's

    Hi all, I’ve got a dashboard that has numerous sheets on it from multiple data sources. I’ve used a parameter to allow me to filter across all the data sources at once. The problem is, the dimension that I’ve used for my parameter is a product code that people can’t use for searching. What they need to use is the product name, but this product name dimension is in only one of the data sources. So is there a way for the user to select a product name in a quick filter on the dashboard and have all the vizzes change, even though it's the product code parameter that's filtering all the sheets?  Thanks!

  • Issue#3971: Tableau - How to display one value by dimension and the other value shows subtotal only

    Hi, I need to prepare a margin comparison file while the 'Margin Var' needs to be show by categories and the 'Profit Var' only needs to show a total. Pls. refer to attached tableau file, what I want to achieve for Dept A is:Margin Var <: -30Margin Var >: 7Profit Var:  10 Anyone has any idea? Thanks! Emily

  • Issue#4630: Tableau - Make a boundary dimension from shape files polygon?

    Hi all, I have read Simon's article about how to make our own boundary from shape files in QGIS into tableau from here Step By Step Instructions – ShapeFile to Custom Polygons using Open Source GIS (QGIS)  I've successed on that one. And now the question is, how to make the polygon boundary (latitude, longitude) into dimension boundary? i hope it is not to type the latitude and longitude 1 by 1 to the Calculated Filed Thanks Randy

  • Issue#6204: DAX issue with Date data type

    I am having an issue today with a DAX formula. The scenario is as follows. I have 2 Power BI desktop files which are formatted identically. I have them linked to separate Excel workbooks which are formatted identically. I am inserting a calculated column into both datasets under "Modeling" in Power BI with the following formula: Week_Crctd = if(weeknum('Line Calls'[Date])<=52,(weeknum('Line Calls'[Date])),1)In one PBI desktop file, I receive the expected result; a whole number between 1 and 52 which varies correctly according to the [Date] value. In the other file, I receive the following error: ï»¿ As I mentioned before, both Excel files are formatted with the exact same number formatting in these columns and both PBI desktop files are formatted with the same Data Type, Format, Data Category, and Default Summarization. What gives? Thanks guys and gals

  • Issue#14980: Notebook - XPS 9350 - Bad cable or laptop?? - USB Type C Issue

    I'm troubleshooting an issue I've run into with my recently purchased Dell XPS 9350, which has the new skylake processor and USB Type C connector for video-out instead of mini DP. When connecting the USB Type C -> Displayport cable from my laptop to my external monitor, I get all kinds of flickering, flashing, screen tearing, and snow on the monitor. It is completely unusable. It doesn't matter what resolution or refresh rate is selected. (All drivers are updated, thunderbolt firmware is... XPS 9350 - Bad cable or laptop?? - USB Type C Issue

  • Issue#17947: Tableau - Scenario: Creating Stacked bars with different measures and split by one dimension wit per

    I have a scenario like, have to create a stacked bar in single report, not in dashboard. 1) Create 2 stacked bars (eg:  measure 1 - sales, measure 2 - profit), split colors by categoryBut the problem is i cant show percent and actual values in labels, i can only show any one either % or value. But i want to show both 

  • Issue#19649: Tableau - One dimension for one column in a sheet

    Hi.I've this issue:I'd like to create a sheet with a number of "columns", each for every Dimension.If I choose only 6 dimensions all works fine and I can see every dimension in a separate columnIf I try to add another (7th) dimension (i.e. "Cost per Share")I see the first two dimensions joined in a single column  The question is:is there any way to have every dimension (beyond only 6 ) in a single, dedicated,  column ?Thanks in advance

  • Issue#29202: Tableau - Daily Total Cumulative Average

    Hi there, I am trying to display a graph of our cumulative total average each day. Here is an example of the data structure: DateStar RatingReview1/1/164comment 11/1/164comment 21/1/163comment 31/2/161comment 11/2/161comment 21/2/162comment 31/2/165comment 41/2/165comment 5 I am able to display a line graph of the average rating per day, however I'd like to display a cumulative average for total ratings over time. For example, the chart would have these data points along the graph - DateCumulative Average1/1/163.66 vs. 3.66 daily1/2/163.125 vs. 2.8 daily I tried this formula however the averages do not come out correct. 

  • Issue#31491: Tableau - URGENT - YTD and Previous YTD calculating from start of the year to till date of both of t

    Hi All,  The Fiscal starts from Oct 01 and ends on Sep 30.  I need two values  1. Year to date (for the current year) - 01 Oct 2015 to till date (30 Jan 2016) - Sum of Incidents from 01 Oct 2015 to till date (30 Jan 2016) 2. Previous Year to date (for the previous year) - 01 Oct 2014 to till date (30 Jan 2015) - Sum of Incidents from 01 Oct 2014 to till date (30 Jan 2015) Can someone please look into this and show me the step by step approach of how to do it.  TIA  Warm Regards,Srinivas

  • Issue#32742: Tableau - How to show totals

    Hi.I've this workbook :I'd like to swow the Total at the end of the column "Current Value" like this: Wich is the best (easy) way?Thanks in advance.

  • Issue#35545: Tableau - Adding within a dimension

    Hi,  I have the following chart.  I need another account that calculates the difference (essentially a plug) between the yellow highlighted accounts and EBITDA.  The chart should be the yellow highlighted accounts plus an additional line for "Other" all summed to equal EBITDA.  Is there a way to accomplish this?  

  • Issue#44025: Tableau - Best way to format Grand Totals row

    Hi !I'd like to know wich is the best (and easy...) way to format only the Grand Total row: i.e. to change character font, dimension, bolf, italic, etc... only for the Grand Total rowThanks in advance

  • Issue#45185: Tableau - How to do YTD and MTD calculations in MSAS cube?

    There are very less resources and examples pertaining this question.Please refer to the screenshot below. It shows the dimension and measure names of my cube. I referred to the link below for YTD and MTD calculations.Microsoft Analysis Services Cube: MDX Calculation for YTD,MTD and Today()I have been using the following calculated member to find out MTDSUM(MTD(Strtomember("[DIM TIME].[Date].&["+format(now(),"mm/dd/yyyy")+"]")),[Measures].[SALES AMOUNT]) It does not give me any result. Note: This link is helpful tooMTD & YTD Columns from Analysis Services Cube

  • Issue#49238: Tableau - count down from total sum

    hello all, i think i got a simple task for Tableau but as i am still learning i would like a little guidance please  i got a dataset with 2000+ drawing numbers and a date next to them showing when authorised,i have been able to create a calculated field that counts the authorised dates and then map this on line chart by date (screenshot) i would like to have a count down from the sum total, so instead of showing the amount of drawings issued that month, i want to show how many drawings are left in total per month so in December instead of 166 we would have around 1700  any help would be great thanks

  • Issue#52469: Tableau - total or sum of groups

    Hello, I tried searching the forums for an answer to this, but I'm trying to show the totals for each "department" as seen in the screenshot below.. so for COM I'd like to show the sum of CNTD(Stac ID) and the sum of Active Students Count eg - COM - 22 34 I'm working on attaching a sample workbook, but I have to anonymize the data etc... I feel like it's something close to a window_sum(countD()) but I can't seem to make it quite right.. any help is (of course) appreciated!