KNOWLEDGE BASE

Grand Totals Showing Unexpected Numbers with COUNTD


Published: 13 Mar 2017
Last Modified Date: 13 Mar 2017

Issue

When you turn on Grand Totals for a field aggregated to COUNTD (count distinct), the totals may not show the expected number. 
For example, if you are using an Excel file containing the following data: 
Screenshot of a spreadsheet with two columns, Region and Fruit
If you place Region on Rows and CNTD(Fruit) on Text, you will get a grand total of 3, where you would expect two fruits sold in each of two regions to add up to 4: 
User-added image

Environment

Tableau Desktop

Resolution

Select Analysis > Totals > Total All Using > SUM.
The Grand Total will now show as 4. 
User-added image
 

Cause

By default, Grand Totals will match the aggregation of the field being totaled.
 
Did this article resolve the issue?