Hello All
I am trying to see whether we can add a row called Total which can be an aggregate of all Rows.
For ex: In the Superstore Sample there are 3 entries in the Category Column : (1) Furniture (2) Office Supplies (3) Technology
Now in the same Category Column I need another entry called "Total" which is Sum of all 3 elements (Furniture;Office Supplies;Technology )
I have tried Sets etc but its not working.
Also I need to see if this a % Calculation then SUM rollup wont work. hence need Aggregate etc .. Any ideas ?
The previous person was on the right track but a simpler version is to just do a dual axis. So for your example, you currently have 1 sum(sales) pill in the rows shelf. also, you have a category pill in the colors mark.....this is good for the first part.
From there, duplicate sum(Sales) so you have 2 pills on the row shelf. then, make it go to a dual axis. note: sometimes Tableau will change the chart type to a bar or bubble once you create a dual axis. you can manually force them back to a line chart.
Then, in the marks shelf...got to the 2nd sum of sales and make sure you do NOT have the category dimension on the color shelf, so it's only 1 color.
