BusinessObjects Board

How to filter out zero values in a bar chart

other Xcelsius - Crystal Dashboard Design
#1

Hi,
I’ve got a table that looks roughly like this:

Data Q1 Q2 Q3 Q4
East 159 117 433 152
West 0 152 457 352
North 147 0 199 542
South 0 152 157 522

the quarter totals of which I’m showing in a pie chart.

When I select a segment of the chart I want to be able to see the breakdown in a bar chart but I dont want to see the records with a zero value.

How do I filter out the records with zero values in the bar chart.

Thanks

Stuart.

Smithsc (BOB member since 2008-10-08)

#2

Hi,
I’ve developed a dashboard for similar. my data has few 0 values , so i’ve used a combo box to filter the data (to get non-zero values). and the destination on that combo box is mapped to PIE chart . iam attaching file hope that would solve your issue.
pie_test.zip (12.0 KB)

phang7 (BOB member since 2014-03-21)