View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dale1948 dale1948 is offline
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