Grand Totals Showing Unexpected Numbers with COUNTD

Published: 13 Mar 2017
Last Modified Date: 18 Apr 2018


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


Tableau Desktop


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


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