Can I have zero values chart against selection with no data.

[#1]

Hi everyone ,

     I am facing a problem which I am explaining below, can anybody address this ?

I have 2 dimensions "Year" and "Product"

=====================

Year

=====================

2008

2009

2010

2011

=====================

=====================

Product

=====================

A

B

C

D

E

F

=====================

=====================

Product          Year     Sale

=====================

A                   2010       1

A                   2011       2

B                   2010       3

B                   2011       4

C                   2010       5

C                   2011       6

D                   2010       7

D                   2011       8

E                   2010       9

E                   2011       10

F                   2010       11

F                   2011       12

======================

Now the problem is when I select Year 2008 or 2009 then against these years there are no sales(no records) so chart does not display saying "No Data To display"

So my question is can I have a chart with zero values against these years ?

[er_mohit]

in presentation tab uncheck suppress zero value

hope it helps

[Sokkorn]

Hi,

Check this post may help you.

Regards,

Sokkorn

[#4]

Hi Sokkorn ,

But in your case sum for July was calculated because there was a record of July but its sales was - so which caused sum as 0 , But in my case you can say July exists in Date table(Filter) but does not have any associated records in fact table. How can I do this in the following case. I am attaching sample files and what i want is when I select June, July then chart should show 2 bars but bar of July should have 0 value.

[sushil353]

Please find the updated file

HTH

Sushil