Descendants

Returns the set of descendants of a member at a specified level.

Syntax

CODE

Descendants( Member_Expression , Level_Expression )

Member_Expression	MDX expression that returns a member.
Level_Expression	MDX expression specifying a member level for the set.

Set_Expression	MDX expression that returns set of particular level members

The example below would return the average Gross profit monthly for the selected year

CODE

Avg( 
 Descendants(
  [Time].[Year].CurrentMember,
  [Time].[Month]
 ), 
 [Measures].[Gross profit base amount]
)