Pretty new to AirTable and struggling to work out how to achieve this.
I have 2 tables - product data-base and orders.
I created a Rollup field for the SUM of sales for each product variant (Variant ID). This worked great, but I don’t want to see total sales only the last 7 days sales. I.e. TODAY - 7. I’d like this to update dynamically each day
Is there a formula which will sum the last 7 day sales by variant from ‘Orders’ and feed this into ‘Product Database’?