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

[Frank_Hartmann]

Is this what you want to achieve?

[Kushal_Chawda · Accepted solution]

see the attached

[yashcena]

Yes ...this is exactly what I was looking for.

Thank you so much!

Can you tell me what you did for it?

[yashcena]

Can you tell me what you did for it? I wanted to change the label to 'Average' instead of 'Total'.

Thank you!

[Kushal_Chawda]

You can go to presentation tab -> For head count -> Label for total ,  put 'AVG'

[Kushal_Chawda]

Also you wanted the avg numbers instead of Total, in attached QCW I have changed the expressions to get the Avg number

[yashcena]

Thank you! Actually, I wanted to know what you did that the 'Subtotal at Bottom' option is taking average and not sum.

I'm a beginner in qlikview, forgive me for asking trivial question!

Thanks..Yash

[yashcena]

Ah..got it now

thanks again!

[Kushal_Chawda]

I have used Dimensionality() function, when it is zero expression for avg will work else normal expression. Refer the expressions in attached QVW file