The easiest way to get Total on top of each category is that
using 2nd axis to show Total.
At first you will see 100 % overlaid picture, but you can remove color from 2nd axis.
Put measure name pill to color shelf and you can choose color
and you can also change the name in the legend.
This is sum of all profit / sum of all sales across all category with below formula.
You can see that is aggregated value in the shelf with "AGG(**)".
Tableau_Sample_SS(2) SM _9.2.twbx 287.7 KB
1 of 1 people found this helpful
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.