Sum and Create Rows for Different Time Periods

[ContinuousLearning]

Hi Alteryx community,

I have been struggling to organize my workflow and I was hoping I can get help here. 

I have the following structure of my file:

I want to create a new variable that adds/subtracts two or more variables for a specific scenario (001_ or 002_). 

Example: I want to create a new variable that will have VarName labeled Accruals and would sum AccrInt+AccrIntBeforeSales + AccrInvInc for each time step (Value000, Value001, etc)

I am attaching the excel version with the desired output. I have to mention, in my actual workflow, I have a lot of variables and scenarios. 

I appreciate any suggestion!

Thank you!

[ArtApa]

Hi @ContinuousLearning - This is how you can do this:

[ContinuousLearning]

Thank you for your solution. Unfortunately, it won't work for my workflow, since I can have multiple scenarios. Is there anything else I can use instead of the sorting tool?

Thank you!