The Top Percentile and Bottom Percentile filters return the Members whose cumulative value for a specified Measure is within a given percent of the total value.

 

In effect, what these filters do is sort the Members according to the value of the Measure (largest-to-smallest in the case of Top Percentile and smallest-to-largest in the case of Bottom Percentile) and starts adding the values of the Measure for each Member.  The process stops as soon as the cumulative value grows larger than the specified percent of total value.

 

Examples:
- Customers that amount to 80% of total sales

 

The Top/Bottom Percentile Editor

Component	Description
1	The percentile
2	The Measure 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 in May-2008 amount to 80% of total sales in May-2008.

 

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.