first, thanks for the wonderful app I just found!
I set up several tables which essentially track sales. There are three different product categories, for each of them I set up a table names with the category ID. The three tables are identically, basically consisting of a unique product ID, date of sale and amount for the product (calculated using a formula from other fields).
What I am now trying to figure out is a way to calculate the total amount of all sales by month and by product category. Ideally I could somehow show the total income for all product categories in a given month or for a given month classified by product category.
Is it possible with Airtables or does anyone have a good idea for a 3rd party app that does that?