Hi! I’m trying to calculate the amount of sold items in the last 30 days, based on another sheet that contains all purchase orders from my clients. Currently, i’m using “show references from existing sheets” to get all of the data into my product sheet (red), then using a formula to calculate sum of sold items in the last 30 days (yellow).
I would like to get the same result without bringing in a whole new table into my product sheet. Have been experimenting with aggregate field, but there doesn’t seem to be a way to filter aggregated data by date.
Is there another way to achieve this?