1 Reply Latest reply: Mar 26, 2013 1:07 PM by Gysbert Wassenaar RSS

    Ratio to third level subtotal

      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)