Good morning,
I have created multiple pivot tables with the date as the report filter. Upon updating and refreshing the pivot table, the dates in the report filter become unsorted. In order to update these pivot tables, I now have to scroll throughout the entire list to find the dates to select. I hope to find a way to sort the dates in order. The end result I am looking for would be to select 1 business week (Mon-Fri) with each pivot table 1 week out of each month. I have only inputted just one pivot table, but in essence would have one for each week for the month of March. I am using excel 2010. I have attached a spreadsheet for an example.
Thanks for your help.
Bookmarks