When you right-click a member's cell you get these options:

  • Sorting. Member sorting always applies to the selected level. You can choose a sort order of:
    • Ascending (A-Z)
    • Descending (Z-A)
  • Filtering. Member filtering always applies to the selected level.
  • Label filtering. You can use these text comparisons to filter the level members.
    • Equals
    • Not equals
    • Begins with
    • Not begins with
    • Ends with
    • Not ends with
    • Contains
    • Not contains
  • Value filtering. Value filtering applies to the total value for each member. You can use these numeric comparisons:
    • Equals
    • Not equals
    • Greater than
    • Greater than or equals
    • Less than
    • Less than or equals
    • Between
    • Not between
  • Ranking. You can select only the top or bottom members of a level by value by selecting a member and selecting Top 10. You can have a different ranking on each level.