View the original community article here
Last tested: Sep 21, 2020
Totals for table calcs work by apply the table calc logic to the totals of the measures that are referenced in said table calc.
In other words,
- For any fields referenced in the calculation, the totals are computed. (This will fail for dimensions because they are not included in the totals query.)
- The calculation is applied to the totals computed in step 1.
For example, if we had a table calc that is ${measure1} + $[measure2}
. The total of this table calc is ${measure1:total} + ${measure2:total}
, rather than computing ${measure1} + $[measure2}
for each row and then totaling them somehow.
This content is subject to limited support.