I created a Custom View that displays records from an employee table joined with a table that stores the text value for some codes that we use. In Design view for the list page, I activated the Filter option for a few of the columns. When I navigate to the list page URL, I can use the filter but after I apply it, the list does not change. For example, one of the fields is 'Rank'. If I click on the Rank filter in the column header and only select 'Captain', the filter icon changes to show the funnel but all of the records still appear in the list.
What is even weirder is that when a filter is applied, I still see all of the records but if I click on an additional filter, I only see options for records that meet the first filter condition. For example, I apply the same Rank filter for Captain, the only remaining record should be Captain Jones. If I click on the 'Last Name' filter, I only see 'Jones' in that list. (But the list page still shows all records).
Any thoughts on why records are not filtering off on the list page? Thank you!