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:
Is that what you were expecting?
Hi,
Use this expression
If(RowNo() = 0, Sum(Sales)/Count(TOTAL <Country> DISTINCT JOB) , sum(Sales))
Regards,
jagan.
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.
Thank you all.