SUM
Description:
This function is used to return the sum of a numeric expression evaluated over a specified set.
Syntax:
Sum( Set_Expression [ , Numeric_Expression ] )
Return type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
Numeric_Expression | It is a valid numeric expression, typically an MDX expression of cell coordinates that returns a number. |
Example:
with member [Measures].[S] as
sum([Customer].[Geography].[Country],
[Measures].[Internet Order Quanlity])
select [Measures].[S] on 0,
subset([Customer].[Geography].[Country],2,7) on 1
from [AdventureWorksMF]