-
In the column header you want to filter values for, select the Filter icon .
-
Use the Filter by Column Data dialog to apply the filter:
-
In the upper part of the dialog, select from the list of values listed in the column using the check boxes.
-
Type in the Search field to narrow the available selection if required.
-
Use the Select All check box to select or clear all the check boxes for the list of values.
-
The values in the list beside the check boxes show distinct strings only; therefore, if an identical string appears in more than one row in the grid, that string is shown only once in the list.
-
The list can contain up to 1000 distinct strings.
-
If a column includes empty values, a check box with the value [empty] appears in the list.
-
-
In the Show rows with value that section, select the required operator from the list, then type a value in the blank field, and if required, select And/Or. When filtering numerical data with units of measure, the filtered results are sorted in order of SI value regardless of the units.
-
-
When you have finished adding criteria to your filter, click Filter to display the filtered results.
-
A filtered column is indicated by a solid Filter icon .
-
If filtering is already applied and a filtered value is changed to a new value outside the range defined by the filter, the row with the new value is immediately excluded from the grid display.
-
To remove the filter criteria for a specific column, select the Filter icon and in the dialog for filtering the column data, select Clear Filter.
-
When pagination is invoked, filter applies to the entire data set.