PROD
Description:
This function is used to return the product of a numeric expression evaluated over a specified set.
Syntax:
Prod( Set_Expression [ , Numeric_Expression ] )
Return type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Numeric_Expression | A valid numeric expression, typically an MDX expression of cell coordinates that returns a number. |
Example:
with member [Measures].[Reseller Unit Price Product] as
prod([Employee].[Department].[Department], [Measures].[Reseller Unit Price])
select
[Measures].[Reseller Unit Price Product] on columns,
[Employee].[Department].[Department] on rows
from [AdventureWorksMF]