KNOWLEDGE BASE

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

Issue

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].

Environment

Tableau Desktop 

Resolution

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

Cause

This behavior is related to a known issue with ID 634746 which is currently under investigation.
Did this article resolve the issue?