KNOWLEDGE BASE

How to Only Show Measure Field in Grand Total, Not in the Crosstab


Published: 01 Jul 2022
Last Modified Date: 04 Jul 2022

Question

How to only show a measure field in grand total, not in the crosstab (Measure Values)? 

For example, only show the Profit in grand total, not in each category?
User-added image

Environment

  • Tableau Desktop

Answer

The ability to only show a measure field in grand total is not currently built in Tableau Desktop.
Please consider the workaround below.

Show grand total in another worksheet and merge 2 worksheets in a dashboard.
The image is as follows.
User-added image

Please check the attached video and workbook for details.


 
Did this article resolve the issue?