4 Replies Latest reply: May 23, 2013 4:47 AM by Sushil Kumar RSS

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

      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 ?