Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to show missing values as zero in straight table.
Dim: Month
Measure: Sum(Revenue)
Raw data:
Month | Revenue |
1 | 100 |
2 | |
3 | |
4 | 200 |
5 | |
6 | |
7 | |
8 | |
9 | |
10 | 300 |
11 | |
12 |
Required output:
Month | Revenue |
1 | 100 |
2 | 0 |
3 | 0 |
4 | 200 |
5 | 0 |
6 | 0 |
7 | 0 |
8 | 0 |
9 | 0 |
10 | 300 |
11 | 0 |
12 | 0 |
Total | 600 |
Thanks,
Krishna
Maybe with: alt(Sum(Revenue), 0)
- Marcus
Hi!
Maybe this?