Aggregate

Return to: Calculated Member Builder Function List

Returns a calculated value using the appropriate aggregate function, based on the aggregation type of the member.

Syntax

Aggregate(«Set»[, «Numeric Expression»])

Remarks

This function cannot be used on calculated members.

Example

Consider the following expression:

WITH MEMBER Geography.Total AS  'AGGREGATE({USA, France})'

SELECT {Measures.SumSales, Measures.MaxSales} ON COLUMNS,

      {USA, France, Total} ON ROWS

FROM SalesCube

WHERE ([1998])

In this expression, the calculated member Total is displayed first against the measure SumSales and then against the measure MaxSales. In the former case, Total is calculated by adding (with Sum) and in the latter case, Total is calculated by taking the maximum.