Filter a Report with Values
You can filter rows with data when creating a report.
To filter columns or rows that contain values, complete the following steps:
- In the report layout area, click the down arrow beside Row Labels or Column Labels.
- On the next dialog box, select the Values Filter option. A shortcut menu displays that includes filter options such as Equals, Greater Than, and Between.
- Select a filter command from the list.
-
On the
Value Filter (<field name>) dialog box, enter the filter criteria.
For example, if you select Greater Than and the field being filtered is Total Labor Hours, enter the greater than number of labor hours.
- Click OK to return to the newly filtered report.