How to get the Average in place of total in pivot table.
Thanks in advance.
And in Presentation tab Change caption to Average in Labels for Totals text box for both Country and JOB dimension. PFA for solution.
I guess by using dimensionality() function we can achieve this
I guess something like this:
but i did not get a chance to implement.
try this and let me know.
I have attached the solution yesterday itself. check out
use the expression :