2 Replies Latest reply: Sep 29, 2017 5:59 AM by Vikas Nandanwar RSS

    Addition of Calculated Field

    Vikas Nandanwar

      Hi All,

       

      I have my data in below

       

      I need a calculated field in pivot giving result as -

      [Sum 2016(USD) - Sum 2015(USD) ] / [Sum 2015(USD)]


      Please help.

       

      YearUSD 20152016Growth
      20162000Sum of USD20700218005.02%
      20162600
      20162800
      20163400
      20163000
      20166600
      2016800
      2016600
      20155400
      20154600
      20154200
      20152000
      2015700
      2015300
      20152200
      2015800
      2015500

       

      Regards,

      Vikas