topPercent

Sorts the set specified in "set_expression" in descending order and returns the topmost elements from the sorted set whose cumulative percentage of the total is greater than or equal to "percentage".

Syntax

topPercent ( set_expression , percentage , numeric_expression2 )

Example

topPercent ( set ( [Camping Equipment] , [Golf Equipment] ,
 [Mountaineering Equipment] ) , 40 , [2006] )

Result

For the set of Camping Equipment, Golf Equipment, and Mountaineering Equipment, returns the members with the largest Gross profit whose total for the year 2006 is at least 40% of the overall total.