Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two groups of salesmen, A and B
Total sales per salesman per month is set into a class
Now I want to know the number of salesman per group per class per month/ in a percentage of total number of salesman per group per month.
I can't succeed in counting the number of salesman in the divider (per group,per month)
Edit : found the correct expression for a pivot table :
=count(distinct name)/aggr(nodistinct count(distinct name),month,group)
Now I have to put it in a chart.
I think you issue is the calculated dimension. Is there anyway you can create the classes in the script?