cancel
Showing results for 
Search instead for 
Did you mean: 

Combo Box

Former Member
0 Kudos

Hi,

I have two combo box

1st drop box: All, SIT, Dev, Test

2nd drop bpx: All, 40k, 50k, 60k

Spreadsheet:

Name      env        cost          application

-----------------------------------------------------------

A             SIT        40               aaa

B             Dev        50              bbb

C             Test        60             cccc

D              Dev       50              ddddd

E              SIT        60              cvvv

F              Tet         40              sdsd

When i select 1st and 2nd combo, speradsheet data should display accordingly our selection in combo box.

Im facing challenge in selecting ALL.

Can anyone give some samples or scenarios, how to achieve.

Regards,

Rajesh

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Rajesh,

What is the source of the data ?? Is it WEBI ??

For this scenario i suggest create the raw data (or webi report output) as follows

Name      env        cost          application

-----------------------------------------------------------

A             SIT        40               aaa

B             Dev        50              bbb

C             Test        60             cccc

D              Dev       50              ddddd

E              SIT        60              cvvv

F              Tet         40              sdsd

All            SIT        40               aaa

All           Dev        50              bbb

ALL           Test        60             cccc

ALL           Dev       50              ddddd

ALL           SIT        60              cvvv

ALL           Tet         40              sdsd

A             SIT        ALL               aaa

B             Dev        ALL              bbb

C             Test        ALL             cccc

D              Dev       ALL             ddddd

E              SIT        ALL              cvvv

F              Tet         ALL              sdsd

Thanks,
Srinivas Adepu

Former Member
0 Kudos

If the source is WEBI report

Just adding unioin queries will work perfectly. Here you have to create dummy objects in Universe for Name and cost with select clause as "ALL" .

Then in first union query drag the all the objects and instead of Name drag the dummy name object.. repeat the same in 2nd union query for cost object.

Thanks,
Srinivas Adepu

Former Member
0 Kudos

Srini,

This one xcelsius dashboard. Not using any data source.

From dashboard, how to achieve.

Regards,

Rajesh

Answers (1)

Answers (1)

Former Member
0 Kudos

ok.. Then you can try this.

save the selection from the combo boxes in the xcelsius spreadsheet.

Add one more spreadsheet component for 'ALL' selection on top the original component and use the dynamic visibility.