Trouble getting totals on pivot table

[#1]

Hi,

Please find attached Qlikview document (link to Test.qvw). There's no sensitive data in it. Can any of you experts out there tell me where I'm going wrong in my attempts to get the pivot table to show a Total at the bottom of 5700? Apart from the lack of the Total at the bottom, the pivot table is exactly as I want it. I thought that having the Show Partial Sums option in the Presentation tab ticked for the MonthYear column would do the trick but apparently not.

Many thanks in advance.

[pover · Accepted solution]

Try the expression:

=if(dimensionality()=0,sum(aggr(avg(Value),month_year)),avg(total <month_year> Value))

Regards.

[#3]

Thanks Karl. That works perfectly! Much appreciated!

Ian