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 |
|---|---|
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:
| Code Block | ||
|---|---|---|
| ||
select [Measures].[Internet Order Quanlity] on 0,
BottomSum([Product].[Product Categories].[Sub Category].Members
, 10
, [Measures].[Reseller Average Sales Amount]) ON 1
FROM
[AdventureWorksMF] |