Hello Team,
I have a simple scenario.
Suppose the below dataset , 3 columns ,
Category , Year and Sales
2014 2015 2016
Office 100 150 190
Furn 50 80 110
Total 150 230 300
Final Output Expected
2014 2015 2016
Office (150 - 100 ) / (230 -150) (190 - 150) / (300 -230)
Furn (80 - 50) / (230-150) (110 - 80) / (300 -230)
How to achieve the same?
5 respostas
see the attached
you use this
where YoY is your original calculation
([YoY diff]) /window_sum(([YoY diff]))
Jim
