Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to get the Average in place of total in pivot table.
Thanks in advance.
Required output:
Hi,
And in Presentation tab Change caption to Average in Labels for Totals text box for both Country and JOB dimension. PFA for solution.
Regards,
Jagan.
Within the tab presentation in the top left you could set a total-name for each dimension.
- Marcus
Hi Wizard,
Check in the presentation tab.
Hi,
I am using PIVOT table, need Average.
I guess by using dimensionality() function we can achieve this
I guess something like this:
if(dimensionality()=1,RangeMax(0,avg(Slaes)))
but i did not get a chance to implement.
try this and let me know.
Not working.
No Sure if you need this.
See attached.
Hi Qlikviewwizard,
try this
Any solution please.
I have attached the solution yesterday itself. check out
edit:
use the expression :
If(Dimensionality()=2,
round(Sum(Sales)),
round(avg(aggr(sum(Sales),Country,JOB))))