Ranking can be applied to a member set in the same way. 

Choose whether to display the top or bottom products. This can be determined by an Excel cell and how many members to display. This can be static or determined by an Excel cell. See Drive Reports from Excel.

  1. Select whether to return the top or bottom members. An Excel range can determine this.
  2. Select how many members to return. This can be based on:
    • Count: a defined number of members, for example, top 10 members
    • Percent: The members that make up a percentage of the total, for example, customers that contribute the top 10% of sales.
    • Sum: Return the members until their cumulative sum has reached the defined value.
  3. Select which measure to rank by:
    • Current measure: use the measure currently used in the grid filters
    • This measure: manually define a measure to use
    • Measure in slice: rank by a certain slice, such as sales amount in a particular period.
  4. Select whether to Exclude zero values and Exclude nulls from the ranking.