Discussion Board for collaboration related to QlikView App Development.
How to get the Average in place of total in pivot table.
Thanks in advance.
And in Presentation tab Change caption to Average in Labels for Totals text box for both Country and JOB dimension. PFA for solution.
Within the tab presentation in the top left you could set a total-name for each dimension.
Check in the presentation tab.
I am using PIVOT table, need Average.
I guess by using dimensionality() function we can achieve this
I guess something like this:
but i did not get a chance to implement.
try this and let me know.
No Sure if you need this.
Any solution please.
I have attached the solution yesterday itself. check out
use the expression :