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]
  )