Use the Report:
Filter narrows the focus of a Report and only returns the
records that meet the criteria. This example uses the data to select
only the movies that were released in a particular year, not all
Try it: Filter the Records in a Report
is still opened in Layout View.
Select a Column: Years.
Go to Home->Sort&Filter.
Click on Filter.
What Do You See? The Filter should be available by the Field
This, Too: Select Only One Filter
default, there should be check mark in Select All. Clear that
check mark and all of the Filters will be cleared as well.