how to sum by product dynamically

[grant_S]

salesman	product	quantity	Total
A	N1	2	9
B	N1	3	9
C	N1	4	9
A	N2	4	15
B	N2	5	15
C	N2	6	15
A	N3	6	21
B	N3	7	21
C	N3	8	21

i have above table, and want to have a new sum when filter the salesman, my expectation as below:

filter salesman A and B, total should be changed base on current view,

salesman	product	quantity	Total
A	N1	2	5
B	N1	3	5
A	N2	4	9
B	N2	5	9
A	N3	6	13
B	N3	7	13

how to write the formula for new Total

[rubenmarin · Accepted solution]

Hi, I think this is a table with salesman and product as dimensions and 2 expressions:

- quantity: Sum(quantity)

- Total: Sum(TOTAL <product> quantity)

[grant_S]

it cannot work as expected, directly sum the total but not by product.

[MayilVahanan · Accepted solution]

Hi

Expression: Sum(TOTAL<product> quantity)

Not in set analysis like Sum(TOTAL {<product>} quantity), its means ignore Product selection.