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
vba pivot table sorting joemeshuggah Excel Programming 1 August 13th 08 03:05 PM
Pivot table - sorting Adam Excel Programming 0 May 22nd 08 09:42 AM
Pivot Table Sorting dale1948 Excel Worksheet Functions 0 August 25th 06 12:10 AM
sorting in pivot table Dennis Cheung[_2_] Excel Programming 3 April 26th 05 08:43 AM
sorting in pivot table Dennis Cheung[_2_] Excel Programming 0 April 21st 05 03:58 AM


All times are GMT +1. The time now is 02:14 PM.

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

About Us

"It's about Microsoft Excel"