Hi All
I have a data set as below:
| LOB |
Number |
Flag |
Amount |
| A |
1234 |
0 |
100 |
| A |
4567 |
1 |
150 |
| A |
7890 |
1 |
50 |
| B |
3344 |
1 |
200 |
| B |
6677 |
0 |
300 |
| B |
8899 |
1 |
400 |
First, I created a straight table with below dimension and expression.
Dimension: LOB, Number
Expression: Sum ({<Flag= {1} Amount)
| LOB |
Number |
Flag |
Amount |
| A |
4567 |
1 |
150 |
| A |
7890 |
1 |
50 |
| B |
3344 |
1 |
200 |
| B |
8899 |
1 |
400 |
Now, my requirement is I need to write another expression as below but as soon as I am doing it, I am getting all the data in the straight table and not as per the above expression. Basically, the expression below should work only on the data which is filtered by the expression mentioned above.
Expression to be added: If (LOB <> Above (Total LOB),'1A','1B')
