When filtering list vies, lookups and option set fields allow user to filter on data that isn't even available in the current view. Filters should only show values for records that are in the view to streamline the user experience.
For instance, option set called "Color" has values are Red, Green, and Blue. The current view only has records for Red and Green. When filtering the view, user should only be presented with Red and Green to filter because no records have Blue.
Comments
Exactly the same when we talk about countries, regions, cities....
IF your view shows a determined country, you have in the filter for Regions all regions in all countries. Once you selected the region, then you have all cities in all regions.
Must be a dynamic filtering, making only possible to select the filter for the available data shown in the current view.
Category: General