MrExcel . Joined Feb 8, 2002 Messages 3,014 Office Version 365 Platform Windows Sep 13, 2006 #1 When I create a pivot table with customers down the side, they are always sorted alphabetically. How can I make it sort by revenue? (Descending)
When I create a pivot table with customers down the side, they are always sorted alphabetically. How can I make it sort by revenue? (Descending)
Greg Truby MrExcel MVP Joined Jun 19, 2002 Messages 10,014 Sep 13, 2006 #2 Hi Bill, Assuming revenue is a data field? Double click the top of the Column Field (A3?) and click the Advanced... button and then change the Using Field setting in the dropdown at the bottom left of the AutoSort options settings. Solution
Hi Bill, Assuming revenue is a data field? Double click the top of the Column Field (A3?) and click the Advanced... button and then change the Using Field setting in the dropdown at the bottom left of the AutoSort options settings.