Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
Strange behaviour between pivot and normal table.
The normal table shows the correct total. The pivot table not. Any ideas?
Thanks, Tom
If you are using a manual total, such as "Sum of rows", in a table, that will often have a different result from a Pivot table's total (which is just the formula aggregated across the entire dataset). Make sure your formula is written correctly such that it will sum both at the SEM_BCS account level and the total level.
Hi @TomBond77
To calculate the correct total, use Aggr() in the expression. Include all the used dimensions in the pivot within the Aggr().
=Sum(Aggr(Sum(Actual),Dim1,Dim2,Dim3 ...))