Display Sum on Top of Stacked Bar
Let's create a chart like this.
It's pretty nice view already, but typically I got additional request.
Which is "Can you add total value on top of Stack bar?"
Answer is Yes, then let's try.
1st, add calculated field.
[Total Sales]
total(sum([Sales]))
K, no error, seems right, put this fields into Label
mmm... Some things are not right....
First of all, sum for horizontal is not I want. I will correct this.
Looks reasonable.
It's changed, and number looks correct. That's good.
However, you see same number on each color... We don't need three of them...
Looks like we need to cahgne our approach.
K, here is a right/easier way.
Right click on Y-axis and select "Add Reference line"
You can see it now. The point is put Reference Line, but without "LIne".
Like this case, Add some function "with INVISIBLE feature" is one of the important "TIPs" in Tableau.
It does not show whole digit right now, then change the numebr format.
This is a final view.
Let's play aruojnd and Enjoy!