Data rollover from previous month to current month

[Meghnagupta]

Hey,

I have attached same excel. My requirement is I want data to be copied from "MTI Cumulative Current" to new column "MTI Cumulative Current Previous" when I run this next month/ quarter

Say, currently value in "MTI Cumulative Current" is "181892.4" so when I run this next month "MTI Cumulative Current" will have some other value e.g.: 1234567 but "MTI Cumulative Current Previous" should have "181892.4"

This need to be done for a lot of columns, in this i have given 2 columns only "MTI Cumulative Current" and "DivReinv Cum Current"

Input
Fiscal Yr	Month	Date	Award Short	Dept at Reporting Month	MTI Cumulative Current	DivReinv Cum Current
2026	1	1/13/2026	PSU	10106	181892.4	85583.2
2026	1	1/13/2026	RSA	10106	158167.3	74420.18
2026	1	1/13/2026	PSU	10106	264380.5	47598.4
2026	1	1/13/2026	RSA	10106	251791	45331.81
2026	1	1/13/2026	PSU	10106	12469.77	9457.34
2026	1	1/13/2026	RSA	10106	12469.77	9457.34
2026	1	1/13/2026	RSA	10106	110367.7	51929.73
2026	1	1/13/2026	RSA	10106	127113.5	22885.19
2026	1	1/13/2026	RSA	10106	5381.33	4081.31
Required Output
Fiscal Yr	Month	Date	Award Short	Dept at Reporting Month	MTI Cumulative Current	MTI Cumulative Previous	DivReinv Cum Current	DivReinv Cum Previous
2026	1	1/13/2026	PSU	10106	123456	181892.4	345354	85583.2
2026	1	1/13/2026	RSA	10106	876876	158167.3	5765757	74420.18
2026	1	1/13/2026	PSU	10106	798876	264380.5	79879	47598.4
2026	1	1/13/2026	RSA	10106	4453	251791	5765765	45331.81
2026	1	1/13/2026	PSU	10106	65765	12469.77	7676	9457.34
2026	1	1/13/2026	RSA	10106	656754	12469.77	32432	9457.34
2026	1	1/13/2026	RSA	10106	32432	110367.7	4654	51929.73
2026	1	1/13/2026	RSA	10106	5757	127113.5	4345345	22885.19
2026	1	1/13/2026	RSA	10106	576575	5381.33	97987	4081.31

Can someone help me do this?

[Gaurav_Dhama_]

You need to have two inputs to your workflow, one that takes in the current data and one that inputs the last month report.

Using the last month report rename the MTI Cumulative Current to MTI Cumulative Previous, and use join to get them together.

Just a note, it says cumulative, but the amounts are not cumulative as there are multiple entries on same day under same Award and same "Dept_at_Rptng_Mth". With this data, you may find it difficult to join back the correct amounts.

[Meghnagupta]

@Gaurav_Dhama_  : I am trying to achieve this without including another input. If that is possible and yes "MTI Cumulative Previous" is just the roll over from previous month, it's not as it's name suggest.

[Gaurav_Dhama_]

Does your input data contain the previous period data? Like snip below.

If yes, then we will just have to split the data into two stream and work with it.

If previous data is not present in the current input, then I am afraid you are left with only two options.

1. Ask user to upload the previous period file.
2. Save another output to a permanent location such as SharePoint, Shared Drive, One drive, etc. Every time Alteryx runs, it can pick the most recent file from this location and use it as the previous period data.

This is because Alteryx cannot update any information within itself.

All of the above is under the assumption that you are going to run it on gallery.

If you are planning to run it on designer alone, then you can store the output with a standard name in the containing folder so that every time it runs it overwrites the previous file, this will ensure you have last period data always.