Dropdown and Table Manipulation

[former_member836140]

How can I list down on second dropdown for example cities of a country under an id number selected on the first dropdown base on the filtered table in SAP Analytics Application. Basically, when I select an ID number on the first dropdown it will list all the cities under that ID number. Can someone help me with this ?

[former_member836140]

I just want the city branch under an ID number to be listed on the dropdown

Thank youuu for the answers that you can share.

[N1kh1l]

geraldsampayan28

Follow the hands on tutorial at below link. It describes step by step how to achieve a cascading filter.

https://developers.sap.com/tutorials/sac-analytics-designer-create-4-cascading.html

Hope this helps !!

Nikhil

[saurabh_sonawane]

Hi

This blog will help you.

https://blogs.sap.com/2020/06/24/create-cascading-dropdown-in-sac-designer-without-hierarchy/

Note the above block uses 3 table to get the data of dropdown you can use same table for all 3 dropdown to get cascading effects.

Thanks,

Saurabh