How can I grouping data from different fields

Topic Labels: Base design
588 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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