Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Use this as expression:
=sum(Aggr(If(Value1-Value2, Value1-Value2-Value3,0),Company,Ref))
Use this as expression:
=sum(Aggr(If(Value1-Value2, Value1-Value2-Value3,0),Company,Ref))
Try this:
=Sum(Aggr(If(Sum(Value1)-Sum(Value2) <> 0, Sum(Value1)-Sum(Value2)-Sum(Value3),0),Company,Ref))
Thanks a lot both of you
Both the solutions worked like magic on my original file also.