Discussion board where members can get started with QlikView.
Is that what you were expecting?
Use this expression
If(RowNo() = 0, Sum(Sales)/Count(TOTAL <Country> DISTINCT JOB) , sum(Sales))
And in Presentation tab Change caption to Average in Labels for Totals text box for both Country and JOB dimension. PFA for solution.
Thank you all.