Filters data in the grid view by the existing data in the grid. This command only
hides data from displaying in the grid view; it does not delete data from the catalog.
When you select this command, the filtering row appears at the top of the grid. You
can select the columns of data that you want to filter by filtering the data by multiple
columns. To clear the filtering on a column, in the filtering row for that column,
select (All).
To filter a column by partial string matching, select (Custom) to activate a Custom Filter dialog. You can search for partial strings using "begins with", "does not begin with", "contains", and so forth using the asterisk (*) wildcard for multiple characters and a question mark (?) for a single character. Use the And and Or options to concatenate two search criteria.
You must have the Grid View Command 
active to filter. You cannot filter with the List View Command 
. The Filter command is available on the ribbon and on the View menu. You cannot use this command to filter select lists or branch table data.