Average in place of total in pivot table

[qlikviewwizard]

Hi All,

How to get the Average in place of total in pivot table.

Thanks in advance.

Required output:

[marcus_sommer]

Within the tab presentation in the top left you could set a total-name for each dimension.

- Marcus

[Qrishna]

Hi Wizard,

Check in the presentation tab.

[qlikviewwizard]

Hi,

I am using PIVOT table, need Average.

[Qrishna]

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.

[qlikviewwizard]

Not working.

[Qrishna]

No Sure if you need this.

See attached.

[#8]

Hi Qlikviewwizard,

try this

[qlikviewwizard]

Any solution please.

[Qrishna]

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))))