4 Replies Latest reply: Jul 16, 2018 10:10 AM by Sunny Talwar RSS

    Percentage calculation

    Mahitha M

      Hi Experts,

       

      Can any please help me on Below requirement.

       

      I have a  pivot table like below from Measure please help me to calculate the Percentage column

       

      Dimension            Measure(Count(ID))                  Percentage

      Sales     

      Product 1               43                                              -

      Product 2               21                                             21/43 = 48.84%

      Product 3               22                                             22/43=51.16%

       

      Division

      Product 1               4                                              -

      Product 2               1                                            1/4 = 25.00%

      Product 3               3                                             3/4=75.00%


      Thanks in advance