Calculating sequential differnce

[WassimAB]

hi community

I have an input with customer balances from x1 to x720 am looking to calculate two sets of sequential differences/movement across these columns

1. MX the difference between the consecutive balances of Xs
   1. MX1=X1-X2
   2. MX2=X2-X3
   3. MX3=X3-X4
   4. ....
   5. M719=X719-X720
2. MT the difference between the consecutive MXs
   1. MT1=MX1-MX2
   2. MT2=MX2-MX3
   3. MT3=MX3-MX4
   4. .....
   5. MT718=MX718-MX719

Small example for clarity

input table

 

output table

given that i need to handle 720 columns am seeking advice on the most efficient way to set this up in Alteryx.

any suggestions in tools workflows or scripting would be greatly appreciated

Thanks in advance for your help

[binuacs · Accepted solution]

@WassimAB 

[WassimAB]

THANKS .. i really appreciate it

its working as i want