I have encountered limitation of Excel 2000 whereby if a dimension has over a
certain number of member (such as 5000) then it will not show the members of
that dimension. To work around this I would like to only return the top 1000
in relation to a particular measure.

for example
the top 1000 models by dollar.

can this be done?

Thanks.