Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Steve
 
Posts: n/a
Default How do I get a pivot table to sort based on the data items sectio.


  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Steve

please repost with your question in the message body as it's been truncated
and isn't very clear.
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Steve" wrote in message
...



  #3   Report Post  
Sunil Jayakumar
 
Posts: n/a
Default

Hi Steve,

Just click on any cell containing data in the column you want to sort. Then
DataSort, and this will give you a sort menu. It does trigger a different
one when in a Pivot Table.

Hope this helps

Sunil Jayakumar

"Steve" wrote in message
...


www.ayyoo.com/loans.html


Reply
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 Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 07:24 PM
Calendar based on varying information/ Pivot Table General Neil Charts and Charting in Excel 0 February 22nd 05 05:09 PM
Sort in Pivot Table Edgar Thoemmes Excel Worksheet Functions 2 December 22nd 04 03:34 PM
How to create a calculated field formula based on Pivot Table resu dha17 Excel Discussion (Misc queries) 1 December 15th 04 05:39 AM
Pivot table help:calculated field based on previous consecutive va martin Excel Discussion (Misc queries) 0 December 9th 04 08:33 PM


All times are GMT +1. The time now is 05:12 AM.

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"