select {[RunningTotalSubs]} on Columns, CrossJoin([Age Group].[All Age
Group].children, TopCount( { [Country].[State].members}, 5,
([RunningTotalSubs]))) on Rows from [Consumer]
How can I say I only want the top 5 States, without getting the coutries
back, or where country=US
I
tried where [Country].[Country].[US]
The cube is Country, State, City



This gets top 5 countries fine
select {[RunningTotalSubs]} on Columns, CrossJoin([Age Group].[All Age
Group].children, TopCount( { [Country].[Country].members}, 5,
([RunningTotalSubs]))) on Rows from [Consumer]

Not sure what results should look like - will this work?

CrossJoin([Age Group].[All Age Group].children,
TopCount( [Country].[Country].[US].Children, 5,
([RunningTotalSubs]))) on Rows from [Consumer]

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

That woked! Thanks.
"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote