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?