Linking filters not working with 2 or 3 tables.
I tried the linking filters with a single table. The linking worked. When I select a country name the dependable filter shows the state suggestion based on the country name.
Then I use a left join and call cities name. I also make the city name as filter and link to country name state filter. Now the city name suggesting all cities of all countries instead of the filtered country.
Why it is happening?