BOTTOMSUM

Description:

This function is used to sort a specified set in ascending order and returns a set of tuples with the lowest values whose sum is equal to or less than a specified value.

Syntax:

BottomSum(Set_Expression, Value, Numeric_Expression)

Return Type:
SET

Parameters:

Parameter	Description

Parameter	Description
Set_Expression	It is a valid MDX expression that returns a set.
Value	A valid numeric expression that specifies the value against which each tuple is compared.
Numeric_Expression	A valid numeric expression is typically an MDX expression of cell coordinates that returns a number.

Example:

select [Measures].[Internet Order Quanlity] on 0,
  BottomSum([Product].[Product Categories].[Sub Category].Members  
   , 10  
   , [Measures].[Reseller Average Sales Amount])  ON 1  
FROM  
     [AdventureWorksMF]