Compare two months values dynamically

TDB

Hello Alteryx Community!

I’m trying to create a workflow that will compare the last month that has actuals to the previous months actuals, the result being the difference, but I need it to be dynamic.  Meaning, the last month in the data set will not be the current month as the data is 1-2 months in arrears, also each month a new months worth of data is added to the data set.  If the previous month had no actuals then I want it to ignore/show no difference.  I’m not sure if it is better to have the data tall or wide, so my sample data sheet attached has two tabs, one with the data pre-cross tab and on post-cross tab.

Any help would be appreciated!

Actuals Data File.xlsx

ImadZidan

Hello @TDB ,

I think I got you.

To get the data for the latest month only. We add a summary tool of the main input to workout the latest month. We then join to the final output on the latest month. It is dynamic. when your data includes a new month's data it will pick it up.

I hope it makes sense.

See screen shots.