i am new to airtable but i found airtable is an awesome tools!!
i am a sales supervisor and try to use airtable as database for record and analysis.
I have a base with several table, each table has a monthly sales record.
We have several brands which selling in different retailers, so i pull the sales invoice into airtable by row recording which brands, item sold to which retailers.
the key field as below
Year, Month, Date, Brand, Retailers, Item Name, QTY sold, QTY amount.
So i can easily figure out that month performance on sales
However, i just getting trouble to build a summary table, or how to setup and link the sales of each monthly table. So i can campare the monthly sales…