2 Replies Latest reply on Aug 28, 2018 1:54 AM by vij002

    YEar on Year growth alongwith data

    vij002

      Hi,

      Below is my data -

       

         

      IDDateAmount
      113/01/201755
      114/01/201847
      115/01/201689
      119/08/201665
      216/01/201732
      216/01/201741
      216/01/201778
      216/05/201899

      I am able to get Amount for each year (in the filter) for each id ike -

         

      ID201720182016
      15547154
      2737899

       

       

      I would like to add 2 more columns where i can see difference of the amount fromthe previous year, so YOY growth. so 2017 compared to 2016 and 2018 compared to 2017

       

      Kindly suggest.

       

      R