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:

  1. In the report layout area, click the down arrow beside Row Labels or Column Labels.
  2. 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.
  3. Select a filter command from the list.
  4. 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.

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