2 Replies Latest reply on May 3, 2018 1:55 AM by sudheer.kumar.5

    LookUp for a dynamic time period

    Dilyana Suleymanova

      Hi there,

      I have follow table

      I see the sales in the time period from 1.01.2018 until 31.03.2018

      I want to compare the same period (from January untill March) with one year before (2017)

       

      Both numbers should stay in one column. The difference should be given in %

       

      Accessories = 8.515/4.891 = 1,74 -> in  2018 the accessories sales rose 74%. (in compare with 2017)

       

      I built a calculation field with lookup: LOOKUP(sum([Sales]),-1)

      But it doesn't work

       

      Any ideas?

      Thank you!