ignore null value - Pie Chart

other Xcelsius - Crystal Dashboard Design
1

Hi,

i have a problème with the pie chart component which does not ignore null values in serie or value.

there is a combobox on my dashboard, with which a user can choose a department of the company.

Once a department is selected, the pie chart should represent the ditribution of the deparment expenses by sub department. and department have not the same number of sub department. that’s where I can have empty series!

So if anyone know how to set a dynamicaly sized datasource for the pie chart, that would be great!! any other idea are welcome of course :slight_smile:

thanks!!

julien.alegre (BOB member since 2009-02-03)

2

Hi

What version are you using? With Xcelsius 2008 SP1 FP3 this works fine. See the attached.
ComboPie.zip (5.0 KB)

cdavies :uk: (BOB member since 2005-01-28)

3

try using filtered rows~

jclj (BOB member since 2009-08-11)