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".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
12 | |
5 | |
5 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |