KNOWLEDGE BASE

How to show the total sum value on the top of the stack bar


Published: 11 Apr 2022
Last Modified Date: 12 Apr 2022

Question

How to show the total sum value on the top of the stack bar 

Environment

  • Tableau Desktop 2021.2.7
  • Windows 10
  • Cloudera Hadoop Hive

Answer

Workaround 1

Use reference line - If the negative exist, the total sum reference line will be placed in the middle of stack bar.


Workaround 2

Use dual axis - Create the second axis and make the marks as text. The total value will be shown, however the total value number is still in the middle of the stack bar if the negative value exist.  


Workaround 3

Creating calculation field and add the calculation field in the label, move the label on the top of the stack bar. The label is only related to some of the category, if the relative category is removed or filtered, the value may be wrong.

Workaround 4

Create annotation instead of dynamic values.

Attachment is a sample workbook includes 4 workarounds. 
Did this article resolve the issue?