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
|