Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Section Access...
Opps.. thanks for the notice:
user: servit
Pass: servit123
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)