Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default How do I sort a Piviot table by the Total field in Excel 2002

I need help with how to sort Piviot table not in alph order. and using a
total.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 560
Default How do I sort a Piviot table by the Total field in Excel 2002

On Thu, 13 Sep 2007, in microsoft.public.excel.charting,
"
said:

I need help with how to sort Piviot table not in alph order. and using a
total.


Use Right click.. Field.. Advanced.. Autosort Options.. Ascending.. by
Total

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.
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
Excel 2002 : Any single button to get sub total and grand total ? Mr. Low Excel Discussion (Misc queries) 2 May 22nd 07 08:46 AM
CUSTOM FIELD OR SUB TOTAL IN PIVOT TABLE FARAZ QURESHI Excel Discussion (Misc queries) 0 February 13th 07 11:52 AM
Using '% of Total' in calculated field in Pivot Table goofy11 Excel Discussion (Misc queries) 2 May 9th 06 11:32 PM
Change selected field in all piviot tables dcozzi Excel Worksheet Functions 0 March 15th 06 05:16 PM
Problems with Pivot Table Field Sorting in Excel 2002 Phoenix71555 Excel Discussion (Misc queries) 1 February 27th 05 11:25 PM


All times are GMT +1. The time now is 01:49 AM.

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"