KNOWLEDGE BASE

Grand Totals Do Not Show for Measure Values


Published: 29 Jan 2013
Last Modified Date: 05 Apr 2017

Issue

Selecting Show Row Grand Totals or Show Column Grand Totals in a view that contains various measure values does not cause a Grand Totals column to appear.

 

Environment

Tableau Desktop

Resolution

To show Grand Totals for measure values, you need to create a calculated field to add the measures together. 

To show Grand Totals for measure values:
  1. In the original worksheet, drag the measure values on to the Text area on the Marks shelf and drag Measure Names to Columns.
  2. Create a new worksheet and call it "Grand Totals."
  3. On the new worksheet, create a calculated field. For more information, see How to Create a Calculated Field.
  4. In the calculated field, add the measures together. For example, [Profit] + [Sales].
  5. Drag the newly calculated field to the Text area on the Marks shelf.
  6. Add the Grand Totals worksheet and the original measures worksheet to a dashboard and align the worksheets so that the Grand Total value from the Grand Totals worksheet is parallel to the measure values.
 

Cause

Tableau calculates Grand Totals only for multiple items within a measure, not across different measure values.  

Did this article resolve the issue?