bottomSum

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

Syntax

bottomSum ( set_expression , value , numeric_expression )

Example

bottomSum ( members ( [great_outdoors_company].[Products].[Products].
[Product line] ) , 6000000 , tuple ( [2006] ,
 [great_outdoors_company].[Measures].[Gross profit] ) )

Result

For the Product line members, returns the members with the smallest Gross profit whose total for the year 2006 is at least $6,000,000.