Skip to main content

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.

TitleContinentCountryCityStreet
Title1AsiaIndiaMumbaiMG Road
Title2AfricaSouth AfricaDurban

GT Road

Title3AsiaIndiaPuneCST
Title4AsiaIndiaNagpurOrange road

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.

184889_pastedImage_0.png

I have not tried the second option as yet. Let me know if you came right.


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


Reply