Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

krishna_2644
Valued Contributor III

Re: Average in place of total in pivot table

Is that what you were expecting?

MVP & Luminary
MVP & Luminary

Re: Average in place of total in pivot table

Hi,

Use this expression

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

Regards,

jagan.

Highlighted
MVP & Luminary
MVP & Luminary

Re: Average in place of total in pivot table

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.

Arjunarao
Honored Contributor II

Re: Average in place of total in pivot table

Thank you all.