Filtering Table Data

Filtering data in a table filters the data displayed in the table columns. You can apply filters in the Table section in addition to any filters set in the originating section. Filters set in the Table section are automatically propagated to any other reports that inherit their data set from the table. You can apply only one filter per column.

To return data to the display and make it available for reporting, delete or suspend the filter.

  To filter data in a table:

  1. Double-click a column, or click the column heading and select Table, then Filter.

    The Filter dialog box is displayed.

  2. Select an arithmetic or logical operator from the drop-down list box.

  3. Define the potential filter values by selecting one of the following options:

    • Show Values—Shows column values associated with the item.

    • Custom Values—Supplies an empty field for inputting custom values. Select the check mark to add a value to the list.

  4. In the Values list, select the values to include in the filter definition.

    Individually select values or click Select All and deselect the values that you do not want to include.

  5. When the values are highlighted in the values pane, click OK.

    The filter is applied to the column and the column name is added to the Filter line.

  To remove a filter in a table, select the filter item and choose Table Remove, then Remove.

  To remove a filter in a table, select the filter and do one of the following:

  • Click the Delete key.

  • Select Table, then Remove.

  • Click Remove on the shortcut menu.

  To remove all filters in a table, click Filter on the Filter line and select Table, then Remove.

  To remove all filters in a table, click Filter on the Filter line and do one of the following:

  • Click the Delete key.

  • Select Table, then Remove.

  • Click Remove on the shortcut menu.