Sum (MDX)
Returns the sum of a Measure evaluated over a specified set.
Syntax
Sum( Set_Expression, Measure )
Input Parameters
Set_Expression
A valid Multidimensional Expressions (MDX) expression that returns a
set.
Measure
A basic Measure.
Return Value
Returns a value of the same type as Measure equaling the sum of the Measure evaluated over the given set.
Examples
Returns the Sum of salesamount1 over a 30 period window on the [Order Date Dimension].[Order Retail445] hierarchy.
Sum(
[Order Date Dimension].[Order Retail445].CurrentMember.Lag(29)
:
[Order Date Dimension].[Order Retail445].CurrentMember,
[Measures].[salesamount1]
)