Compare 2 Dimensions in Chart

[ashishpalkar]

Hi There

I have below requirement,

I have 2 Dimensions Month Header and Month Header 1.

Expression : Sum(Total)

Month Header is showing me list of months and their respective totals.

Month Header shows me all the months irrespective of available totals.

e.g Month Header - Jan Feb Mar Apr Jun Oct Dec

     Month Header 1 - JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC

What i want to do , on X axis of chart display all months , whenever total is not available for that months display '0'.

Thanks

[sunny_talwar]

Can you share some sample data to see how the data looks?

[settu_periasamy]

Hi,

May be try this..