I have two columns 2016 and 2015 representing the years from the Year column. Each of these years has values for example:
The columns(2016 , 2015) are generated dynamically. I want to calculate the percentage by taking value of 2016 and dividing it through the value of 2015. Now the question is, how can I get to the values? I tried to do it through this expression, but It is not working properly.
I've created a matrix to show you the required setup.
Note Prozent is outside the Year column group. It produces:
Let me know if this helps.