Top 10 List?

[katams]

I have a region dimension and geography dimension that I'm trying to generate a top 10 list from...
Example:
Region 1 Top City 1 Top Zip 1
Top Zip 2
Top City 2 Top Zip 1
Top Zip 2
Top Zip 3...
Region 2 Top City 1 Top Zip 1
etc...

Geography has the levels state, city and zip. Any ideas?

Thank you in advance!

 

[mikeG77]

Hi, This MDX-statement should solve your problem:


select
{ [Measures].[YOUR_MEASURE] } on columns,
TOPCOUNT (CROSSJOIN({ [region].[all region].children }, { [geography].[zip].members }),10,[Measures].[YOUR_MEASURE])
on rows
from YOUR_CUBE