Calculate Difference between Scenarios

[hellyars]

Okay,

I'm a little rusty, I have not touched Alteryx for a few months.

I want to calculate the change from each Scenario (S1, S2...S19) to the other.   S1 would = S1.  S2 would =S2-S1.  S3 would = S3-S2 etc.

What is the most efficient way to do this?  I do not want to create an expression for each field.  

Sample data attached as yxdb.

[Qiu · Accepted solution]

@hellyars 
I think we can do it with the Transpose and Cross Tab Tools

[binuacs]

@hellyars I agree @Qiu solution is the most simple and elegant solution. Another option using the Multi-Field tool

Spoiler