LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Pivot Table Sorting

I have developed a pivot table that lists a number of salespeople and their
customers in the row fields, and sales in the data field. Each salesperson's
sales are subtotaled above the individual customer sales numbers. I would
like to sort the sales numbers for individual customers in decending order,
under each salespersons sub total.

When I try to sort one group, another group is unsorted. There must be
someway to do this.

Thanks!

Dale
 
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 2k Pivot Table refresh scenario GDCross Excel Discussion (Misc queries) 1 June 1st 06 09:12 PM
Pivot Table - Sorting on Sum field and filterin [email protected] Excel Discussion (Misc queries) 0 May 30th 06 11:07 AM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
Pivot Table - Multiple consolidation Range tengreen Excel Worksheet Functions 1 July 1st 05 07:18 PM
Sorting pivot table drop-down Joyce Excel Discussion (Misc queries) 1 May 23rd 05 11:50 PM


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