topic Pivot Table - Partial Sum Wrong Calc in QlikView

Pivot Table - Partial Sum Wrong Calc

orital81 — Mon, 28 Oct 2013 13:22:52 GMT

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 — Mon, 28 Oct 2013 13:27:39 GMT

Section Access...

orital81 — Mon, 28 Oct 2013 14:20:14 GMT

Opps.. thanks for the notice:

user: servit

Pass: servit123

orital81 — Mon, 28 Oct 2013 15:01:14 GMT

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)