8 Replies Latest reply: Jan 16, 2017 8:53 PM by Sunny Talwar RSS

    Pivot table with calculation year to year

    Vitalii Chupryna

      Hi,

       

      I'm trying to create pivot table with following structure, but can't correctly calculate Evolution.

      In my model I have weight and height and based on it I calculate index as Heigth/Weigth.

      Evolution should be counted by comparing current year with previous (2017 vs 2016, 2016 vs 2015, 2015 vs 2014)

      Can someone help with set expression.

       

         

      Year2014201520162017
      Weigth81879198
      Height179181184190
      Index0,450,480,490,52
      Evolution 6,222,894,29