Like Pivot Tables? Yes me too, I love them, but have you ever wanted to sort them differently, for example to show the top Sales Month by volume.
Here is how to do it….really easy…
- Click on the Month Column
- Go to More Sort Options
- Choose Descending
- From the drop down menu pick Sum Of Sales as the criteria
- Click Ok and that is it!
How do you sort your Pivot Tables?
Other Pivot Table Stuff…..
Refresh all of your pivot tables with one click
Get PIVOTDATA when you don’t want to
Create running total in Excel with pivot tables
