2 Replies Latest reply on Jul 24, 2015 12:15 AM by Tableau kumar

    one measure as a percentage of another measure

    saurabh.c.0

      Measure Names field has been placed on column shelf and i have text table as below                

                              Measure1    Measure2     Measure 3

      Dimension             10             20                30

       

      I want to calculate percentage as : 10/(10+20+30) , 20/(10+20+30)  , 30/(10+20+30)

       

      Please tell me how to do that

      result expected as below

                              Measure1    Measure2     Measure 3

      Dimension           in   %              in%         in %