Pivot Table Partial totals not working properly.

[nithin_miryala]

Hi Everyone.

In the below pivot table i have enabled partial totals for ID.

I want the total to be different sum of the Top rows. but it is defaulting to Expression total.

It is working the way it should Visits as the expression is Sum(Visits).

But when it comes to AMGA and MGMA there is some multiplication going on expression level. Rather than just adding the columns the total is also being calculated.

is there a way i restrict it to sum.

Thanks

Nithin

[sunny_talwar]

Aggr() function is for the front end of the app... doesn't work in the script....

[nithin_miryala]

I was referring to all the other feilds