Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table where I calculate ratios of the values to the subtotals.
I was using the following expression to divide each cell by the first subtotal(second level):
count(distinct Person)/count(distinct total <[Dimension1]> Person)
Now I need to group it by 2 dimensions. I need to divide by the second subtotal(third level)
How can I adapt the expression to be used with 2 dimensions?
This way is not accepted:
count(distinct Person)/count(distinct total <[Dimension1]> <[Dimension2]> Person)
You can simply list the dimensions separated by comma's:
count(distinct Person)/count(distinct total <[Dimension1],[Dimension2]> Person)
You can simply list the dimensions separated by comma's:
count(distinct Person)/count(distinct total <[Dimension1],[Dimension2]> Person)