1. User's Guide
  2. Defining Members
  3. Filtering Members

Filtering Members

Define filters to view only members that meet your criteria. You can then select from the filtered list for your report.

For example, you can display Regions in the United States division only. Filters are useful for reducing the number of members that are displayed.

To define filters:

  1. Open a report and select a grid.
  2. Double-click a dimension cell.
  3. In the Select Members dialog box, in the Members tab, right-click inside the Available area and make one of the following selections:

    • Select Filter, and then Custom, highlight the lists of available functions, then click the Add button, Right Arrow icon, to move them to the Selected area.

    • Select Filter, and then Predefined, then highlight the desired list.

  4. Click OK.
  5. Click OK to return to your report.