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: 12 May 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 


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 is currently under investigation.
Did this article resolve the issue?