Hello,
I have a sample data set like the below.
Sometimes, retailers announce sales before the official release date of a product.
I need to group up all the pre-release sales of a product in the database and include them in the release week entry.
Retailer | Product | Product Release Date | Current date | Sales |
A | A | X | Z-1 Week | 10 |
A | A | X | Z | 5 |
A | A | X | Z + 1 Week | 5 |
End result :
A / A / Z - 15 sales
A / A / Z+1 - 5 sales
Solved! Go to Solution.