Filter a Report with Dimensions

You can filter columns or rows that contain dimension data when you create a report.

To filter columns or rows that contain dimension data, complete the following steps:

1. For the field that you want to filter, complete one of the following actions:

   • In the PivotTable Field List, click the down arrow beside the field name.

   • In the report layout area, click the down arrow beside Row Labels or Column Labels.

2. On the dialog box that opens, complete one of the following actions:
   • Clear the check box beside any single item that you want to remove from the report and click OK. Use the vertical scroll bar to move up and down the list. You can select the All check box to add all items back to the report.
   • Select the Label Filters option to display a shortcut menu that includes filter options such as Equals, Contains, and Greater Than.
3. After you select a filter command, enter the filter criteria in the Label Filter (<field name>) dialog box.

   For example, if you select Between and the field being filtered is Employee Name, enter the beginning and ending employee name to include in the report.

4. Click OK to return to the newly filtered report.