BOTTOMCOUNT
Description:
This function is used to sort a set in ascending order, and returns the specified number of tuples in the specified set with the lowest values.
Syntax:
BottomCount(Set_Expression, Count [,Numeric_Expression])
Return Type:
SET
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
Count | A valid numeric expression that specifies the number of tuples to be returned. |
Numeric_Expression | A valid numeric expression is typically an MDX expression of cell coordinates that returns a number. |
Example:
SELECT
[Measures].[Internet Sales Amount] ON COLUMNS,
BottomCount([Product].[Product].[Product].Members, 5, [Measures].[Internet Sales Amount]) ON ROWS
FROM [AdventureWorksMF_ValueBased]