2 Replies Latest reply: Jul 17, 2018 4:59 AM by Andrea Gigliotti RSS

    Pivot table percentage calculation help

    Mahitha M

      Hi Experts,

       

      Can any one please help me on below requirement.

      In the below table

      Dimension is Division

      Measure is Count(distinct ID)

      Please help me to calculate the percentage like expected output column.

       

      I have tried like Count(distinct ID)/Count(Total distinct ID) but getting wrong percentage.

      Please help me on this.


      Thanks in advance