How to show sum of rows in a pivot table

[Anonymous]

Hi ,

     for one of my pivot table the subtotals are not correct.....

i'm using aggr function (as explained in the help document) but the result is still  the same ....

could n't figured the issue ... Any suggestion

[swuehl · Accepted solution]

Just embed the complete expression in the advanced aggregation.

Check attached.