The Top Ranking filter returns the Members whose value for a specified Measure is the highest, while the Bottom Ranking filter returns the Members whose value for a specified Measure is the lowest.

 

In effect, what this filter does is sort the Members according to the specified Measure (highest- to-lowest in the case of Top Ranking and lowest-to-largest in the case of Bottom Ranking) and returns a number of Members specified.

 

Examples:
- Products with the most sales
- Customers with the least purchased products
- Products with the most sales in 2008

 

The Top/Bottom Ranking Filter Editor

Component	Description
1	The maximum number of Members to return
2	The Measure according to evaluate
3	The background/scope of the Measure

 

The Measure's Background

It is possible to restrict the calculation of the Measure’s value to the scope of specified Members.  This allows you to filter Members whose Sales are the highest/lowest in May-2008 for example.

 

To define the background (scope) of the Measure, click on the box titled ‘Click to define background’, navigate to the relevant Dimensions and select the Members or Filters to use.