Calculate last week sales based on DATE
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
DATE | SKU | REVENUE | CATEGORY | GROUP | +++++
I've tried to search the forums, but have not found any topic that solves my issue.
Thanks in advance,
Best regards
Erik
Solved! Go to Solution.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
--