Apply Difference formula's column rules to compare with dynamically added columns

Niks_diageo

Hey Guys..,

I have dataset where every month new column added. I want solution on creating

i) difference of column2 - column1 created dynamically for all columns and (as nominator)

ii) need column1 as selected dynamically (as denominator)

please refer attached dataset for the reference..

Thank you in advance.

Regards,

Nikhil Panchal

Alteryx Community_Dataset.xlsx

Qiu

@Niks_diageo 
I tried something as below.
Transpose is a great tool for dynamic requirement. 😁
I have also highlighted the points we need to take care of.

0928-Niks_diageo.yxmd