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:

1. Right-click a row or column member, select Filter, and then Filter.
2. In the left-most field in the Filter dialog box, select the filter type:

   • Keep: Include rows or columns that meet the filter criteria

   • Exclude: Exclude rows or columns that meet the filter criteria

3. In the middle field, select an option to set which values to keep or exclude:

   • Equals

   • Greater Than

   • Greater Than or Equal To

   • Less Than

   • Less Than or Equal To

4. In the right-most field, enter the value to use for the filter.
5. Click Filter Row or Filter Column.

   The form displays only those rows or columns that meet the filter criteria.

6. To cancel the filter, right-click a row or column member, and then select Cancel Filter.