+9
Hi,
Following is my list structure: Where "Continent" and "Country" are dropdowns,Can I filter the data based on both these dropdowns to show "City" and "Street"?. I have seen the calculated value but I guess it filters based on the value on only one control.
| Title | Continent | Country | City | Street |
|---|---|---|---|---|
| Title1 | Asia | India | Mumbai | MG Road |
| Title2 | Africa | South Africa | Durban | GT Road |
| Title3 | Asia | India | Pune | CST |
| Title4 | Asia | India | Nagpur | Orange road |
+7
Hi Aditya,
Here is a link to Cascading prompts, which would filter Continent first and then Country.
I also think you should be able to play around with the Filter by a specific value options. This should allow you to use two different variables to use as filtering key, but also you will have to have the calculated key value in the table above for Continent - Country. This key field will also then be the focus of your filtering.
I have not tried the second option as yet. Let me know if you came right.
+9
I think I have mentioned in the wrong way, I will have two dropdowns at the top for selecting "Continent" and "Country" and will have a search button,Onclick function will populate a list view with filter conditions
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.