LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
deacs
 
Posts: n/a
Default Sort in Pivot Table


I have a Pivot Table with 3 columns of data. Column A has the Dept
Number, Column B has the Dept Description, and Column C has $ amounts
associated with the Dept in Columns A and B. Is it possible to sort
the data in this Pivot Table by the $ amounts in Column C? If so, I
would greatly appreciate your help in doing this?

In the mean time, I've just copied and pasted special the data in the
chart into a different sheet and performed the sort there.

Thanks in advance!


--
deacs
------------------------------------------------------------------------
deacs's Profile: http://www.excelforum.com/member.php...fo&userid=2321
View this thread: http://www.excelforum.com/showthread...hreadid=478928

 
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
Sort a Column of Dates in Pivot Table Linny Excel Worksheet Functions 2 September 23rd 05 01:24 AM
pivot table sort entries that don't yet appear in table rachael Excel Discussion (Misc queries) 11 September 19th 05 11:29 PM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
Pivot Table Sort & Top List excel_user123456 Excel Discussion (Misc queries) 0 June 23rd 05 08:53 PM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 07:24 PM


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