Formula

psinghania

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

Capture.PNG

patrick_digan

@psinghania I would suggest transposing the data. I've mocked up a simple example to get you started. Hope it helps!

2019-09-27.yxmd