Total on pivot table different to straight table

[TomBond77]

Hi experts

Strange behaviour between pivot and normal table.

The normal table shows the correct total.  The pivot table not. Any ideas?

Thanks, Tom

[Or]

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.

[BrunPierre]

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