hi,
i have created a bar chart for one single customer. That means on the chart i have just one bar (which is what i want). The bar is subdivided into 2 sections based on a 'yes' or 'no' value in another database field called .
in the chart expert in the 'show values' box, i have nothing; i set the drop down box to 'for all records'. In the 'show value(s)' box, i have 2 formulas that look something like this:
formula1: if field='yes' then 1 formula2: if field='no' then 1
in the chart i have set these to 'sum of formula1' & 'sum of formula2'.
the information being displayed on the bar sections is correct. however, if, lets say one sections sum is 0, a 0 is displayed on the chart. How can i get it that if the sum of formula1 (or formula2) is zero, then no value is displayed on the chart. (except for the values greater than 0) ?
thanks.
j