Suppressing nulls in bar chart

[Former Member]

Hi,

I created a Cross tab with Month as row and Volume as column. In the output I have observed some null months in Row so I used "suppress row empty" to get desired output , however when I converted this cross tab into chart , still I can see some null months in the chart , Please suggest how to get rid of null months in Chart?

[former_member205840]

Hi Guruprem,

Go in Record Selection and say

Not(isnull(Months))

Thanks,

Sastry

[Former Member]

Thanks for reply,

I am bringing 24 months for data for Chart purposeI have to showcase only latest 12 months so what I have done is created a formula named "Month" where it takes month name only if month is in last 12 month else blank.  These blanks are hurting us currently in chart.

[former_member205840]

Hi Guruprem,

That is fine, now go in Record Selection formulas and apply a filter like below :

{@Month} <> ' ' or not(isnull({@month})

The formula which you have created to capture months not equal to ' '

Thanks,

Sastry