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.