LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc
external usenet poster
 
Posts: 204
Default Pivot table sort order

Hello, My pivot table (on a seperate sheet in V2003) seems to sort my data
in an entirely random order. It is not in the order that the iems appear in
the original data, and it is not in size or alphabetical order, and what's
more, I can't change the order, even if I use 'Sort & Top 10' or Advanced
'Field Settings.

Why is this?

How can I determine the order? - Ideally it would be in the order tht the
iems appear, but if that's not possible, I could fiddle it, if I could sort
it at all!

Thanks
M

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Sort Order Mustang Excel Discussion (Misc queries) 1 May 4th 09 12:30 PM
sort order of pivot table drill down Amedee Van Gasse Excel Discussion (Misc queries) 0 June 17th 08 02:29 PM
Pivot table sort order ajnmx Excel Worksheet Functions 1 March 27th 07 10:39 PM
Sort order not being matched in pivot table Deanery Phil Excel Discussion (Misc queries) 2 January 8th 07 08:34 AM
Pivot table sort order Vincdc Excel Discussion (Misc queries) 2 March 1st 06 05:20 PM


All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"