Grand total in pivot table different from the sum of the rows...

[flafla92]

I created several pivot tables with calculated fields and it appears that , for those calculated fields, the Grand total value of these columns are different (sometimes lower sometimes higher) from the sum of each individual rows value....

Does someone had the same an issue and an explanation and solution to that ?

Thanks

 

[RoryA]

If you do any multiplication or division in the calculation that can happen because of the way the calculations work. If your field is calculated as =A*B for example, the totals are not worked out as:
=SUM(A*B)
but as:
=SUM(A)*SUM(B)

So, let's say you have a value field and a percentage field and your calculated field multiplies them:

1000 * 5% = 50
2000 * 10% = 200
----------------------
3000 * 15% = 450

is what your calculated field does.

Does that make sense?

 

[Husker7]

Is there a way around this or is the only fix a manual SUM?