Calculating Difference two rows based on same ID

[twildhart]

I have a table of data of Actuals vs Planned results. 

What I would like to do is calculate the delta of Plan vs Actual and sort by the worst delta in the last month. 

Then the output looks like the following with the last month sorted by the the worst Delta so I can identify the place I need to focus. 

[binuacs · Accepted solution]

@twildhart One way of doing this with the batch macro

[twildhart]

Thank you! I will try this. 

[twildhart]

binuacs,

This worked great thank you. I have since built the workflow with the expanded data set and have decided that it would be better to have the ID repeat all the way down matching to the ID's Plan and Delta rather than grouping and having a Null there. I am Really  new to Macros and can't seem to make out how to leave the ID lables in the output. Can you help me with that? 

[binuacs]

@twildhart updated workflow attached. Let me know if you need any further assistance