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 |
---|---|
27 | |
26 | |
22 | |
21 | |
20 |