Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member184839
Active Contributor
6,639

Having read in quite a few discussions stating ‘filtering data from other components other than filters’, this document provides a ‘quick learn way’ for beginner’s on ‘Filtering data using Combo box & List box’. Follow the easy steps below.

Let this be the data, which has Continent->Country->State->Region.

Refer the images right below each step for better understanding.

Combo Box1 :

Combo Box 2 :

Combo Box 3 :

Combo Box 4 :

Output:

But you can do the same with other selectors like List box. This method is used in many scenarios where Drill downs and other complicated functionality needs to be done.
On a further note, use of combo box instead of look-ups functions and few other complicated excel functions is advisable for better performance of dashboard (these combo boxes usually are hidden behind any component, when is used for the functionality).

The sample file has been attached with the extension ".txt", which can be used by renaming the extension ".xlf".

47 Comments
Labels in this area