Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How can I grouping data from different fields

Topic Labels: Base design
322 0
Showing results for 
Search instead for 
Did you mean: 

Hi there,

I created a table showing daily sales of each product by each salesman as follow:

Primary field: date
2nd filed: Name of saleman
3rd field to N field: daily sales amount of each product

those products could be grouped into different product category and we need to summarise the monthly sales into different product categories to perform further anlaysis. I tried to create another table with the below setup:

Primary field: Product Category
2nd field: Name of product (with multiple select).

I’m now stucked as I don’t know how to link the data between the 2 tables to work you the monthly sales by product category. Please share with me your experience.

0 Replies 0