Show Average in Horizontal Pivot Table

[yashcena]

I have a horizontal pivot table which has Months as dimension and 4 expressions.

I have to show the average of 4 expressions for the 12 month period (which is the dimension) at the last.

In the expression tab of the properties screen, I tried to change the Total Mode to Average of Rows but that option is grey'd out for pivot tables.

I have to show the Average just like the Total i.e at the end.

I tried using dimensionality but could not get the expression right. Can somebody help me with this?

Thanks,

YASH

[sandipahire]

How to Get the Average?