I'm working on a project right now that has a list of customers and the sales generated. There are multiple locations for some, and others have just one location. I'm trying to sort the final sum of each customer from highest to lowest while keeping the grouping and have had no luck.
Here's an example of the spreadsheet:
Customer Total Sales
Customer1 800
Customer1 100
Customer1 200
1100 <---The sum is red text
Customer2 6500
6500
Customer3 500
Customer3 400
900
How would I be able to sort this so all the formatting looks the same but the sum is sorted highest to lowest so it would look like this:
Customer Total Sales
Customer2 6500
6500
Customer1 800
Customer1 100
Customer1 200
1100 <---The sum is red text
Customer3 500
Customer3 400
900
Bookmarks