Episode 708 shows how Excel offers sorting rules that allow your pivot tables to be sorted in a certain manner. The old AutoSort option is now hidden behind a dropdown in the pivot table field list.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast.
I'm bill Jelen.
We were talking about pivot tables this week.
Wanna show you a cool trick with sequencing a pivot table.
So, to create the pivot table again Insert, Pivot Table, OK.
Let's say we want to create a report with customer and revenue.
You'll see that automatically Excel Sorts this data alphabetically by customer in excel 2007 is much easier to create a rule that will sort customer by revenue In the Pivot Table Field List I want to come to the top half and hover over the word customer.
When the invisible drop-down appears, in this invisible drop-down I can open the drop-down and choose More Sort Options instead of saying I want to sort alphabetical by customer.
I can say I want to sort Descending by the Sum of Revenue field, Click OK.
and Excel has now sorted that data high low and the great thing is, is if I add more field, so later on I add a product field.
It will still continue within each product to sort the customers high to low.
We've set up a rule and no matter how we change this pivot table, Excel will remember that rule and keep customers sorted high to low.
Well, thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
I'm bill Jelen.
We were talking about pivot tables this week.
Wanna show you a cool trick with sequencing a pivot table.
So, to create the pivot table again Insert, Pivot Table, OK.
Let's say we want to create a report with customer and revenue.
You'll see that automatically Excel Sorts this data alphabetically by customer in excel 2007 is much easier to create a rule that will sort customer by revenue In the Pivot Table Field List I want to come to the top half and hover over the word customer.
When the invisible drop-down appears, in this invisible drop-down I can open the drop-down and choose More Sort Options instead of saying I want to sort alphabetical by customer.
I can say I want to sort Descending by the Sum of Revenue field, Click OK.
and Excel has now sorted that data high low and the great thing is, is if I add more field, so later on I add a product field.
It will still continue within each product to sort the customers high to low.
We've set up a rule and no matter how we change this pivot table, Excel will remember that rule and keep customers sorted high to low.
Well, thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
