Setting and Deleting Filters

Use

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

Procedure

Setting Filters

  1. To set a filter, select one or more columns by clicking on the column header and by choosing Set Filter or Edit ® Set Filter.
  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. Use And Also to enter more than one interval for a column.

    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. Use But Not to exclude certain intervals from the display.

    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 Edit ® Delete Filter.