So if we break down one of the rows
Your Calculation is
[2018 wieghtage]/[2017 weightage]-1
So this is 0/0.125 = 0
Then 0-1 = -1
Why do you have the -1? It looks like the weightage calculation returns a percentage, and traditionally you show differences of percentages by taking one from the other, and not the percentage change of a percentage.
Hope that helps
If you let me know the result you expect for the row example I've used I can take a look.
So you just need to aggregate it at the level you want to calculate
SUM([2018 weightage])-SUM([2017 weightage])/
If you look at your 2017 and 2018 weightage...they are both wrapped in SUM so you need to reflect this in the variance calculation
Thanks Simon, its working now.