I need to be able to sort date in a pivot table using the school calendar, which is July 1, 2016 - June 30, 2017.
I need to be able to sort date in a pivot table using the school calendar, which is July 1, 2016 - June 30, 2017.
Last edited by Wskip49; 04-26-2017 at 06:43 PM.
Add a helper column in source data range. Which should serve as sort index column and place that as parent row index to dates.
Alternately depending on your Excel version, you'd have option to create custom sort list via file options.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks