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