Returns the set of descendants of a member at a specified level.
Syntax
Descendants( Member_Expression , Level_Expression )
Arguments
| Member_Expression | MDX expression that returns a member. |
|---|---|
| Level_Expression | MDX expression specifying a member level for the set. |
Returns
| Set_Expression | MDX expression that returns set of particular level members |
|---|
Example
The example below would return the average Gross profit monthly for the selected year
Avg(
Descendants(
[Time].[Year].CurrentMember,
[Time].[Month]
),
[Measures].[Gross profit base amount]
)