Pushing multiple rows of data with the Combo Box

other Xcelsius - Crystal Dashboard Design
1

We have a scenario where we have to use a radio button with “Month” and “Cumulative” as selectors. We also have a combo box with the month.

Firstly, the radio button is defaulted to Month. When this is defaulted to a month I will get the rows only with the May 2010 as I used the “filtered Rows” for the combo box. I have no issues at this point.

The issue I is when I select "Cumulative ". The way it should push the data to the destination cell is it pass all the data on or before the May month as you see in the 2nd table in the image.

But the way Combo box behaves is it just sends out the data for selected item as in the 1st table in the image.

Is there any way we could achieve this in Xcelsius?

Thanks in Advance
Xcelsius Issue.JPG

Chikki (BOB member since 2006-05-08)

2

Is there anyway we can dynamically change the source data range for the combo box based on what we select?

Chikki (BOB member since 2006-05-08)

3

Hi Chikki,
There is no cumulative filtering option in Xcelsius.

However you could have another column that checks if the month is less than or equal to May-2010, and have a flag on.

With that flag you can do filtered row to include that in your set.

Therefore, for all columns with flag 1, we would include them in the list

Let me know if this helps :slight_smile:
l’ve attached an excel example for you to look at

Cheers
David
cumulative example.xls (18.0 KB)

davidlai (BOB member since 2008-11-03)