Partial sum in pivot does not match with excel sum

[Anonymous]

Hi Experts,

Attaching a sample QV file, in which if I export the pivot table in excel and check the sum of expression column it does not match with partial sum in pivot.

Excel sum is correct which I need on pivot partial sum.

Is there any way to achieve this without changing the dimensions.

Thanks in advance.

[swuehl · Accepted solution]

Use this as expression:

=sum(Aggr(If(Value1-Value2, Value1-Value2-Value3,0),Company,Ref))

[sunny_talwar]

Try this:

=Sum(Aggr(If(Sum(Value1)-Sum(Value2) <> 0, Sum(Value1)-Sum(Value2)-Sum(Value3),0),Company,Ref))

[Anonymous]

Thanks a lot both of you

Both the solutions worked like magic on my original file also.