Hi all,

I’m trying to get the summed sales data for products that occurred in the last year but for the next 12 weeks of todays date e.g. todays date is 10th June 2024, I would want the sales from today until 10th September but in 2023. I don’t know if my thinking is right where I should 1) Look up all occurrences of a sale for a certain product and then 2) maybe using a sum if to sum it all up when the date is in the next 12 weeks. Any suggestions? I have included some sample data below. Its about 110,000 rows of invoiced orders. Thanks for your help in advance.

​Hi all,I’m trying to get the summed sales data for products that occurred in the last year but for the next 12 weeks of todays date e.g. todays date is 10th June 2024, I would want the sales from today until 10th September but in 2023. I don’t know if my thinking is right where I should 1) Look up all occurrences of a sale for a certain product and then 2) maybe using a sum if to sum it all up when the date is in the next 12 weeks. Any suggestions? I have included some sample data below. Its about 110,000 rows of invoiced orders. Thanks for your help in advance.    Read More

​