If I write the query like so, this works on foodmart sales cube

SELECT
{[Measures].[Store Sales]} ON COLUMNS,
CrossJoin(
Gender.Gender.Members,
Topcount([Product].[Product Department].Members,5,[Measures].[Store
Sales])) ON ROWS
FROM [SALES]

I get:
F Produce
...
Canned Foods

M Produce
...
Canned Foods

But, Baked Goods is really number 5 for females (If I did the query without
the join and just put gender.F as a slicer spec you can see this)

I know I saw this example somewhere a while ago, need to get the topcount to
resolve for the current Gender member on each pass thru the crossjoin.

Any ideas?

Thanks again!

Derrick

Never mind, found it...

SELECT
{[Measures].[Store Sales]} ON COLUMNS,
Generate(
[Gender].[Gender].Members,
{[Gender].CurrentMember} * Topcount([Product].[Product
Department].Members,5,[Measures].[Store Sales])) ON ROWS
FROM [SALES]



"Derrick" <derrick1298 (AT) excite (DOT) com> wrote