Description:
This function is used to sort a set in ascending order, and returns a set of tuples with the lowest values whose cumulative total is equal to or greater than a specified percentage.
Syntax:
Aggregate(Set_Expression [ ,Numeric_Expression ])
Return Type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
Percentage | A valid numeric expression that specifies the percentage of tuples to be returned. |
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,
BottomPercent
({[Customer].[Geography].[City].Members}
, 15
, ([Measures].[Reseller Average Sales Amount],[Product].[Product Categories].[Category].&[Bikes])
) ON 1
FROM
[AdventureWorksMF] |