Pivot Table - Partial Sum Wrong Calc

[orital81]

Hi, I am using a pivot table with partial sums.

For some reason I get wrong results for the partial sums

See the example below: Total Projected should be 653+10750 = 11,403 but it shows 12,517.

My expression for Projected is:

sum(Total_PORDER_Line_Balance_USD)*(1+sum(Comp_Proj_Commission/100))

I will appreciate any insight here, see attached file.

user: servit

Pass: servit123

Thanks

[israrkhan]

Section Access...

[orital81]

Opps.. thanks for the notice:

user: servit

Pass: servit123

[orital81 · Accepted solution]

Got the answer from Here.

What I actually had to do is to get the sum of rows from pivot table (and not total of expression)