Grand Totals for Table Calc Incorrectly Aggregated when Calculation Based on Same Data Source Field Has "Total Using" Set

Published: 10 May 2017
Last Modified Date: 26 Sep 2017


When a calculated field has a default total using setting, and a table calculation uses the same syntax inside of the table function, then that default total setting is used for the grand total of the table calculation.

For example:
[Calc A] is SUM( [Sales] )
[Calc B] is WINDOW_SUM( SUM( [Sales] ))

The default Total Using for [Calc A] is set to average . Then the grand totals for [Calc B] will total using average, regardless of the aggregation chosen for [Sales].


Tableau Desktop 


Option 1

Upgrade to Tableau Desktop 10.4. For more information, see Upgrading Tableau Desktop in Tableau Help.

Option 2

As a workaround, modify the syntax of one of the calculations so they are not identical. In the above example, we could modify [Calc A] to be SUM( [Sales] ) * 1


This behavior is related to a known issue with ID 634746 which has been fixed in a recent release of Tableau Desktop. 
Did this article resolve the issue?