I have a pivot table that gets refreshed everyday, and i add a day to it every day, and i make it trail the last 2 weeks. When i refresh the pivot table, the new dates get added after the "blank" field on the drop down to select dates, then when i select them, the dates are out of order and will not re-order. I currently need to create a new pivot table to have the dates from old to most recent. Any thoughts?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Pivot Table Date Order Problem
- Thread starter BGrunt73
- Start date
