Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, I think this is a table with salesman and product as dimensions and 2 expressions:
- quantity: Sum(quantity)
- Total: Sum(TOTAL <product> quantity)
Hi
Expression: Sum(TOTAL<product> quantity)
Not in set analysis like Sum(TOTAL {<product>} quantity), its means ignore Product selection.
Hi, I think this is a table with salesman and product as dimensions and 2 expressions:
- quantity: Sum(quantity)
- Total: Sum(TOTAL <product> quantity)
it cannot work as expected, directly sum the total but not by product.
Hi
Expression: Sum(TOTAL<product> quantity)
Not in set analysis like Sum(TOTAL {<product>} quantity), its means ignore Product selection.