sum rows in a pivot table

Fri, 03 Sep 2010 14:26:40 GMT

I have read through other posts on this and I have not been able to get the syntax correct.

In the screen shot below I am calculating a charge amount for each school based on the % of leads each school had multiplied by a total charge number loaded in for each source.

My issue now is that when the total column in the pivot is displayed the charge amount is using the expression instead of the total amount of charge from each source.

If we look at the first row in the example the total charge should be 201.54+170.77, instead the total column is recalculating the % and charge. From reading the manual as well as the forum this looks like I have to use the AGGR function but i cannot get it to work correctly.

When I try an expression like this all i see are -

SUM

thanks for any help

(AGGR([Share]*SUM(dimBackCharge.Expense),dimBackCharge.Source,dimSchool.AISchools)

topic sum rows in a pivot table in QlikView

sum rows in a pivot table

thanks for any help