I need a help to sum a range of rows from one file and put it in a different file using Alteryx. Below given is an example.
Two Files
1. Previous Month Data
2. Current Month Data
Each file have two columns
1.Month
2.Total
I need to create two new columns in addition to existing columns (1.Cumulative Forecast & 2.Cumulative Actual) in the Current Month Data file.
Cumulative Forecast field should fetch the data from "Previous Month Data" file and sum up of each month like it's given in the example.
Cumulative Actual field should fetch the data from "Current Month Data" itself and sum up of each month like it's given in the example.
Any help how this can be done in Alteryx would be appreciated!
Solved! Go to Solution.
Hey @KrishTech
I would start by joining the 2 datasets together (using month as the key) and then you can use the running sum tool produce your cumulative values :)
Neil
You will arrive the results by using join, running total and select. If you are run to every month then convert this into Macro.