Show TOC

Setting and Deleting FiltersLocate this document in the navigation structure

Use

The Set Filter function enables you to display only those rows that fulfil certain criteria in one or more columns.

Procedure

Set Filter

  1. To set a filter, select one or more columns by clicking on the column header and by choosing Set Filter or Start of the navigation path Edit Next navigation step Set Filter End of the navigation path.

  2. In the Set Filter dialog box, enter the From/To values for each column selected.

    Only rows with data within the intervals specified are shown.

  3. And Also to enter more than one interval for a column.

    Example

    To display data for cost centers 4000 to 5000 and 6000 to 7000, select the Cost Center column, enter 4000 to 5000 in the dialog box, choose And Also and enter 6000 to 7000.

  4. But Not to exclude certain intervals from the display.

    Example

    To display data for cost centers 4000 to 7000 without the data for cost centers 5000 to 7000, select the Cost Center column, enter 4000 to 7000 in the dialog box, choose But Not , and enter 5000 to 6000.

  5. To delete entries for a filter criterium, position the cursor on the appropriate line and choose Delete Condition .

  6. To delete all the entries for the filter, choose Delete Filter .

  7. Choose Copy to copy the filter criteria and exit the dialog box.

Deleting Filters

To go back to the prefiltered list display, choose Start of the navigation path Edit Next navigation step Delete Filter End of the navigation path.