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,microsoft.public.excel.programming
external usenet poster
 
Posts: 204
Default HELP... Pivot table sorting

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? What can I do to sort it?

I have to ba able to determine the order? - Ideally it would be in the order
that the iems appear in the original list, but if that's not possible, I
could probably fiddle it, if I could sort it at all!

I really hope someone can help

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 sorting Soccer boy[_2_] Excel Discussion (Misc queries) 1 February 10th 09 08:15 PM
Pivot table not sorting nathan_savidge Excel Discussion (Misc queries) 2 November 4th 08 04:57 PM
Sorting a Pivot Table cware Excel Worksheet Functions 2 August 26th 08 12:27 AM
Pivot table sorting Compass Rose Excel Discussion (Misc queries) 2 July 11th 08 08:56 PM
PIVOT Table Sorting - PLEASE Help!!!!! John87111 Excel Discussion (Misc queries) 4 June 21st 07 05:49 AM


All times are GMT +1. The time now is 07:17 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"