I have used a pivot table to summarise up data I have on customers.
The display shows the summary brand that each customer has sold and then subtotals each customer layout example below.
Customer 1 Brand 1 £100
Brand 2 £200
Customer 1 Subtotal £300
Customer 2 Brand 1 £100
Brand 2 £400
Customer 2 Subtotal £500
Is there a way of sorting the pivot table so that customer 2 appears at the top as it has the greatest total sales of £500.
Any help appreciated
Ed
The display shows the summary brand that each customer has sold and then subtotals each customer layout example below.
Customer 1 Brand 1 £100
Brand 2 £200
Customer 1 Subtotal £300
Customer 2 Brand 1 £100
Brand 2 £400
Customer 2 Subtotal £500
Is there a way of sorting the pivot table so that customer 2 appears at the top as it has the greatest total sales of £500.
Any help appreciated
Ed
