Filtering and Sorting Data

In the table viewer, you can right-click a column heading to filter and sort the data by that column.

The filter options vary depending on the type of column that you have selected. The Add Filter window for a numeric column enables you to specify one or two filter criteria for each column. To add a second filter criterion, click .

The Add Filter window for a character column enables you to select one or more values in the column.

The Add Filter window for a date column enables you to select a date value from a pop-up calendar window.

When you create a filter on your data, the filter criteria are displayed at the top of the workspace. You can click to edit the filter and to delete the filter.