Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Table:
| ID | DAY | MONEY |
| 1 | MON | 1 |
| 1 | TUE | 2 |
| 2 | MON | 3 |
| 2 | TUE | 4 |
| 3 | MON | 5 |
| 3 | TUE | 6 |
| Benchmark | MON | 7 |
| Benchmark | TUE | 8 |
Want to compare the benchmark like below
| ID | DAY | MONEY | Benchmark |
| 1 | MON | 1 | 7 |
| 1 | TUE | 2 | 8 |
| 2 | MON | 3 | 7 |
| 2 | TUE | 4 | 8 |
| 3 | MON | 5 | 7 |
| 3 | TUE | 6 | 8 |
| Benchmark | MON | 7 | 7 |
| Benchmark | TUE | 8 | 8 |
To achieve this,
I have selected 'ID' and 'Day' as dimensions,
'MONEY' is the expression and the benchmark expression sum({$<ID={4}>}MONEY)
but the result turns out
| ID | DAY | MONEY | Benchmark |
| 1 | MON | 1 | 0 |
| 1 | TUE | 2 | 0 |
| 2 | MON | 3 | 0 |
| 2 | TUE | 4 | 0 |
| 3 | MON | 5 | 0 |
| 3 | TUE | 6 | 0 |
| 4 | MON | 7 | 7 |
| 4 | TUE | 8 | 8 |
What is wrong in my work?
Try
sum(TOTAL<DAY> {$<ID={4}>}MONEY)
Let me try,thanks