Display Sum on Top of Stacked Bar

Let's create a chart like this.

f:id:skn_0410:20160212024210p:plain

 

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

f:id:skn_0410:20160212024651p:plain

f:id:skn_0410:20160212024839p:plain

mmm...  Some things are not right....

First of all, sum for horizontal is not I want. I will correct this.

f:id:skn_0410:20160212024958p:plain

f:id:skn_0410:20160212025401p:plain

f:id:skn_0410:20160212025446p:plain

Looks reasonable.

 

f:id:skn_0410:20160212025520p:plain

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"

f:id:skn_0410:20160212025726p:plain

f:id:skn_0410:20160212025929p:plain

 

f:id:skn_0410:20160212030136p:plain

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.

f:id:skn_0410:20160212030310p:plain

f:id:skn_0410:20160212030504p:plain

 

This is a final view.

 

f:id:skn_0410:20160212030548p:plain

 

Let's play aruojnd and Enjoy!

 

| Tableau Public