Hello Everybody:

Somebody know how I can create a nested ranking from a analysis services
cube, using MDX?.. i mean, sort a parent level using a measure and then sort
a child level using the same measure... something like:

Dimension
Location: Country->Region->City
Measures: Sales Amount

I need get the next results:
Location Sales Amount
Region1 25
City1 20
City2 3
City3 2
Region2 10
City4 6
City5 4
Region 3 5
City6 3
City7 2

Thanks in advance

Rodrigo