An issue when sorting in excel PivotTable
 

I designed a PivotTable in Excel 2003. Data source is a cube in Analysis
Server 2000. I want to sort a measure. e.g. top 10. however, relevant to
dimmension has many levels. E.g. level1---Group (i.e. a, b, c,.....z),
Level2----UserName. it works fine if I sort & top 10 by Group. but an issue
will pop up if I sort top 10 by usernamea and hide level group. it will list
greater than 10 usernames. how can I get accurate results by sort & top 10.
Are there some options to support or fix it in Excel PivotTable?
thanks.
--
Developer
QA Dashboard
Microsoft China Development Centre