Filtering Rows and Columns
You can filter rows and columns to select which rows or columns to display in the form. Filters can keep or exclude members using simple functions that compare against a specified value.
To filter rows and columns:
Right-click a row or column member, select Filter, and then Filter.
In the left-most field in the Filter dialog box, select the filter type:
In the middle field, select an option to set which values to keep or exclude:
Greater Than or Equal To
Less Than or Equal To
In the right-most field, enter the value to use for the filter.
Click Filter Row or Filter Column.
The form displays only those rows or columns that meet the filter criteria.
To cancel the filter, right-click a row or column member, and then select Cancel Filter.