Hi all,

I'm using Excel/Pivot Table to access my cube. I have a very large
dimension, and I would like to retrieve just the top members of it.
I've created a Named Set which has this formula:


TopCount([ProdName].[(All)].AllMembers, 64)


but I'm not capable to used it on the Pivot Table nor to create a
virtual dimension based on this Named Set.


What my solutions to this problem will be?


Thaks