Sorting and Filtering Members

Sorting and Filtering Members

You can filter and sort the members of a level or named set in various ways. To do so:

1. Click the Advanced Options button next to a level or named set or in the header of the Rows or Columns box, as appropriate.

   See Customizing Pivot Table Items.

2. Specify the following options as needed:

   • Filter members — Select this to filter the members by a measure value. Then select a measure and a comparison operator and type a value.

   • Sort members — Select this to sort the members. Then select the measure by which to sort them. Click Ascending or Descending to control how the members are sorted.

   • Return the first n members — Select this to select a subset from the beginning of the set. Then type an integer into Count.

     When you use this option, the system first uses any settings you specified for the Filter members and Sort members options.

3. Click OK.