i have two tables , sales and product details, sales capture data using reference of the product details. i need to calculate the total qty sold,
i need to filter the rows in the sales equal to the product name row and add qty column value
In the product table create a virtual column with the following expression
SUM([Related Sales][Quantity Sold])
User | Count |
---|---|
38 | |
32 | |
30 | |
17 | |
16 |