Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel CSV file format issue... | Excel Discussion (Misc queries) | |||
Excel CSV file format issue... | Excel Discussion (Misc queries) | |||
excel sorting | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |