aggregate

Returns a calculated value using the appropriate aggregation function based on the aggregation type of the expression.

Syntax

aggregate ( < currentMeasure|numeric_expression > within set 
set_expression )
aggregate ( < currentMeasure|numeric_expression > within < 
detail|aggregate > expression )