bottomPercent

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

Syntax

bottomPercent ( set_expression , percentage , numeric_expression )

Example

bottomPercent ( 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 smallest Gross profit whose total for the year 2006 is at least 40% of the overall total.