Calculate last week sales based on DATE

Hi,

I have a huge CSV file where I have all the sales. The date formate is in DATE(dd.MM.yyyy).

I would like to use Alteryx to find the sales last week (minus 7 days) on all SKUs I have and inject that in a new column.

The data table setup

I've tried to search the forums, but have not found any topic that solves my issue.

Thanks in advance,

Best regards

Erik

Preparation

Accepted answers

danrh

I wasn't positive whether you mean the sum of sales over the last 7 days from today, a rolling sum of the sales over the last 7 days for any given date in your data, or the sales that occurred on the day exactly 7 days ago (it sounds like this one?), so I built out an example of each of the three. Take a look, see if these either fix your issue or at least get you pointed in the right direction.

solution.yxmd

All comments

Ladarthure

Hi,

this is what I'd do based on what you say, you could also make it a bit better with using weeknumbers and calculate the sales per week and then join the datastreams.

hope it helped!

awesome guys, thank you!

Danrh, your solution was the easiest one and solved my issue 100% - thank you both for your time to help me!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703