Hi @Matt_Lawry - if you’ve got an orders table similar to this:
Add another column that shows the quantity sold if the order was in the last 7 days - the formula in my base is this:
IF(DATETIME_DIFF(NOW(), Date, 'days') > 7, 0, Quantity)
Now, back in your product table you can roll-up this field:
Hope this helps.
JB