HI,
I have below data set. I used simple formula for addition for current year and previous year. For e.g: I need sum from Jan 2018 to Aug 2018 in same way for Jan 2019 to Aug 2019 for Net sales and Net GM column.
For new month I need to edit the formula to include the current month. Is there any solution to automate this in alteryx so that I dont need to update the formula each month
Solved! Go to Solution.
@psinghania I would suggest transposing the data. I've mocked up a simple example to get you started. Hope it helps!