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
