How to show missing values as zero in straight table.

[Anonymous]

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

[marcus_sommer]

Maybe with: alt(Sum(Revenue), 0)

- Marcus

[antonaks]

Hi!

Maybe this?