4 Replies Latest reply on Jul 3, 2017 12:00 AM by venkat.gunda

    Difference between values in same row

    Toh Wangting

      My data looks something like this :

       

      Category
      Sub Category
      Date
      Type
      Amount
      T1AAA1/1/2015Act 1234
      T1AAA1/1/2016Act YTD5678
      T1AAA1/1/2017Plan9856
      T2BBB1/1/2015Act4578
      T2BBB1/1/2016Act YTD6325
      T2BBB1/1/2017Plan7856

       

      How do I find the difference between the values for 2016 Act YTD and 2017 Plan in % for each category?