...
...
...
...
...
...
...
...
Returns the set of descendants of a member at a specified level.
Syntax
| Code Block |
|---|
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
| Code Block |
|---|
Avg( |
...
Descendants( |
...
[Time].[Year].CurrentMember, |
...
[Time].[Month] |
...
), |
...
[Measures].[Gross profit base amount] |
...
) |