BusinessObjects Board

Multiple rows selected by user input

other Xcelsius - Crystal Dashboard Design
#1

Hi,
I’ve got the following request:
My raw data in Xcelsius looks like this:
look at Raw data.png below

And I want the user to be able to select a brand (pull down) and then display all rows concerning that brand
The behavior should be like this :
look at Behavior.png below

I know I can achieve this by setting a prompt on my source data (brand=?choose brand?) and re-fire this query every time the end-users chooses a different brand value from the pull down.
But I don’t want to re-fire the query to the db. The data is already in my xcelsius file (it’s not that big a dataset performance is still good in xcelsius but querying takes a lot of time, )

I tried the Source Data component but that only allows me to select ONE row, column or value.

Is there a way to achieve this with the help of Xcelsius components?
behavior.PNG
raw_data.PNG

Tiny :netherlands: (BOB member since 2004-11-10)

#2

You want to use Filtered Rows. Search on that keyword, and you should several excellent examples on the web.

Lugh (BOB member since 2009-07-16)

#3

Ok I can see how this works.

But now I want to create ONE master combo box (which allows me to select APPLE or SAMSUNG) and that one combo box value does the filtered row trick for 10 different raw data tables which have the same structure but different measures (like the example showed in the below picture)

B(TW: without using excel formula VLOOK)

Cause I don’t want to have 10 combo boxes
raw_data_2.PNG

Tiny :netherlands: (BOB member since 2004-11-10)

#4

I think I got what I want:

this one fits my needs (I think)

Down side is you will need to create 10 combo boxes, but you hide them for the users…

Tiny :netherlands: (BOB member since 2004-11-10)