Custom Sorting months in Pivot Table - Excel Tips and Tricks
Discover how you can custom sort months in pivot table
Here are the steps outlined in my video.
Add Custom Month List
1) File ~ Options
2) Advanced
3) In General group, click on "Edit Custom Lists..".
4) NEW LIST
5) Add custom month order.
6) OK
7) OK
Sort Month
1) Filter pull down
2) More Sort Options...
3) Ascending (A to Z) by: "Month"
4) More Options...
5) Filter key sort order to custom months
6) OK
7) OK
#tips #excel #shorts #fyp