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:

[Qrishna]

Is that what you were expecting?

[jagan]

Hi,

Use this expression

If(RowNo() = 0, Sum(Sales)/Count(TOTAL <Country> DISTINCT JOB) , sum(Sales))

Regards,

jagan.

[jagan · Accepted solution]

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.

[qlikviewwizard]

Thank you all.