Enable to show all dimensions, with 0 value in expression

[bimala0507]

Hi Experts:

In one of  chart, I have Year and Month as Dimension and Count ( Sales Order Number)  as expression. I would like to show all Year and Months. Currently, if there is no Sales Order for a month, the month doesn't appear. I would like to have Month and value as 0. Tried possible ways of Showing All Values in Dimensions and Disable Suppress missing value in Presentation, but still not able to achieve. Basically I would like to have all Months and Year to be displayed with value 0 or actual value. Can anyone throw some idea on this?

Ex:

Year    Month  No. of Orders

2003    Jan     0

2003    Feb     10

2003    Mar      8

....

2003    Dec     3

Currently Month Jan is not appearing since, No. of Orders is 0

Kind Regards,

Bimala

[ashfaq_haseeb]

Hi,

Go to chart properties Dimension tab --> Select your Dimension and check show all values.

Now go to presentation tab and deselect  suppress zero values.

Let me know if that worked.

Regards

ASHFAQ

[sat_tok52]

Hi ,

Use This Formula

=Num(Count ( Sales Order Number) +0.001),0.00)

you can able to see zero value on your chart.