Returns a number that is calculated by aggregating over the members returned by the set expression. If a numeric expression is provided, this function first evaluates and then sums the numeric expression for each cell in the specified set.
If a numeric expression is not provided, this function aggregates each member within the current query context by using the default aggregation operator that is specified for each measure.
Syntax
Aggregate(Set_Expression [ ,Numeric_Expression ])
Arguments
Set_Expression | MDX expression that returns set. |
|---|---|
Numeric_Expression | MDX expression that returns number. |
Examples
By default members are ordered by name. Aggregated set of members can be used to rearrange order in which members are displayed. For example to reorder Priority dimension and have "Low" as first member and see "Critical" after it (by default arranged alphabetically with "Critical" being the first) add Priority calculated member as follows:
...