Top Percent
Returns a list of top member elements from derived from the given list, that sum to a specified percentage of the total for the entire list. The logic for deriving the list will use the optional numeric data point (which can be a fixed value or a parameter) if supplied. Otherwise, it uses the default selections for the model or the context in which the function was used.
Syntax & Usage
- Create a list from which you want to derive the top percent list.
- Add the Top Percent block to the list, and set the counter from the Insert Arguments window under "Number of Items". This can be a static number or a numeric parameter.
- Select "Exclude from Result Set" if you want to remove the top percent from the list (as opposed to creating a list of top percent elements).
Example
This expression returns a list of the top 25% of Manufacturers by Cost; the given list is the Manufacturer hierarchy, and the Top Percent block is assigned a set value of 25 percent and Cost as the data point:
{TopPercent({AllMembers([manufacturers].[Manufacturer])},25,([measures].[data Cost]))}