I have a query with Product on rows and measures on
columns. This report will show for each Product Group,
the top 20 Products by Gross Sales.

I want the Product dimension to show the top and bottom
levels only - so Product Group and then Product, hiding
the intermediate 5 levels. How can I hide the mid-levels?

I have tried a virtual cube, but can't hide mid-levels in
a dimension unless the keys of every level are unique and
they are not. I can't find an MDX function that fits the
bill either. The only other thing I can think of is to
create another dimension that fits my criteria but there
isn't enough memory for another large dimension.

Can anyone help????
Ta
Paul