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.