The Descendants functionality although in name de reverse of the Ascendants functionality has a lot more options.
Before you read on just a reminder the Geography hierarchy in the Adventure Works sample is: All ==> Country ==> State-Province ==> City ==> Postal Code.
Let’s start with the base:
SELECT Descendants
(
[Geography].[Geography].[Country].&[United States]
) ON ROWS
,
[Measures].[Reseller Order Count] on COLUMNS
FROM [Adventure Works]
