It was my understanding that when a value is selected in a filter on a report, other filters would adjust to only include values from the resulting set of records - i.e. you could only select from values that occur in the record set you are viewing.
For example, in a table where request types are grouped into categories, picking a single request category in a filter would mean you would only see request types relating to that category in the filter for that column.
That's not how filtering is working, so ... has it always been this way, or has something changed?