Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Straight table /dataset as below
SalesRep | Category | Sum(Sales) |
A | TV | 100 |
A | Laptop | 200 |
B | Laptop | 300 |
B | Desktop | 500 |
C | Laptop | 450 |
Since the sales Rep 'A' Sold the Category TV ,I want to exclude Sales Rep 'A' from the chart/Sheet.
The result should be as follows
SalesRep | Category | Sum(Sales) |
B | Laptop | 300 |
B | Desktop | 500 |
C | Laptop | 450 |
Please help
You need to use SET and E() to exclude the TV selling agents. (See attached QVW)
sum({<SalesRep = E({<Category={'TV'}>}) >} Sales)
Sum({<Category-={'TV'}>}Sales)
You need to use SET and E() to exclude the TV selling agents. (See attached QVW)
sum({<SalesRep = E({<Category={'TV'}>}) >} Sales)