Hiding Grand Totals for only Some of the Columns in Tableau Desktop

Published: 23 Nov 2020
Last Modified Date: 10 Mar 2023

Question

How to show or hide only certain Measures Grand Totals in a view containing Measure Names on Rows or Columns. For example in the following screenshot, how to hide the Grand Total of the measure names: Profit Ratio:
User-added image

Environment

Tableau Desktop

Answer

In the Measure Values card of Tableau Desktop, right-click the measure of the Grand Total you wish to hide and select Total using (Automatic) > Hide.

To reproduce this resolution, see the steps below:

From Tableau Desktop, connect to the Superstore sample data source
In a new Sheet, drag Segments to Rows, and Measure Names to Column
Drag Measure Values to Text on the Marks Card
Then select the Analysis top navigation menu > Totals > Show Columns Grand Totals
To remove the Grand Total of Profit Ratio, right click on the Aggregated mark of this measure on the Measure Card (AGG(Profit Ratio)) and select Total using (Automatic) > Hide.

Additional Information

To view the above steps in action, see the video below.
Note: the video has no sound. To view the video in higher quality, click the YouTube icon below to watch it on YouTube directly.