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.
Solved! Go to Solution.
What exactly is compared when calculating the Evolution ? You can give an example of the calculation of Evolution for at least one year?