add criteria for view filter dropdown

View(report) - filter -> auto filter

I need to limit the dropdown values of an automatic filter based on a field.

The drop down does not list out all of the values if there are too many.

Any idea? thanks