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

發佈時間 : 23 Nov 2020
上次修改日期 : 10 Mar 2023

問題

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

環境

Tableau Desktop

答案

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.

其他資訊

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.