Average on a horizontal pivot table

[QlikMo]

Hi,

Can anyone help. I am trying to get an average of all months at the end of the table. I have read other posts about using the dimensionality() function but no matter what I do I can't seem to get the intended result. Could someone advise?

Thanks

[rubenmarin · Accepted solution]

Hi, PFA.

Crete the month field in script to use in aggr.

Check partial sums for month.

Use SecondaryDimensionality() instead of Dimensionality()

2 options for Avg, I created 2 tables.

[QlikMo]

Thank you very much