Hey Airtable Kinds and Queens! Need a bit of assistance for a mere airtable peasant.
I have 2 tables.
One table has: rep ID and other sales data. This data is updated monthly with the amount they sold that month.
ID#, Name, Retail Sales, Date
343, John Doe, $5,000, 1/1/2018
343, John Doe, $2,000, 2/1/2018
Second table has the contact details including email, phone number, etc.
Here is where I am struggling.
I want to create a column that will show the Sales Persons last months sales, previous 3 months average sales and average sales for all time.
I have the tables linked by the ID# so the data is linked.
I can rollup the average for all time, but I’m not sure how to put a date function into the rollup or other field to only give me the average for a specific date rang.
Thank you so much!