Skip to Content
0
Former Member
Aug 30, 2013 at 03:58 PM

Help needed in SAP BO dashboards

24 Views

Hello,

I am looking for expertise recommendation on a requirement I have based on the below data set…

Requirement is to create a list box (labels State), and create a combo box that lists the city. Cascading filtering should occur... Which
means when state Texas is selected in the list box, then cities should be filtered down to Dallas, Austin and Houston in the combo box...

I was able to achieve this by using 2 different destination tables.

My question is….How can I populate the results into one destination table when either state or city is selected ? (as seen in the below screenshot).

If I keep 2 tables, then I need to hide one or the other depending on which filter component is selected (trying to avoid dynamic visibility
and also reduce the number of components)

I hope my question is clear. Please let me know if you have any questions.

Appreciate any help / guidance.

Thanks in advance,

Ann 😊

Attachments

data set.png (8.9 kB)
my result.png (24.9 kB)
desired result.png (25.4 kB)