Any help on the following question is appreciated!
I have a report that I'll be updating each month. After I run the report I'll refresh a Pivot Table and it will update with the latest data. I have 104 one week time periods that I would like to have sequentially in the row of the Pivot Table. Each month when I update the data the oldest 4 one week time periods will drop off and the latest 4 one week time periods will be added. So, the Pivot Table will always have the latest 104 one week time periods in it.
In the report that I'm setting up the weeks come out of the report saying "Week Ending 01-01-17" for example. When I refresh the Pivot Table the order it puts the time periods is not sequential. Instead, the order starts with "Week Ending 01-01-17". Then the second time period listed is "Week Ending 01-03-16." The third one listed is "Week Ending 01-08-17". And it continues from there. Is there a way to have all the time periods order sequentially so that each month when the new data comes in it will automatically order the information sequentially in the Pivot Table when I hit refresh? Is it not ordering it properly right now because the fact that it has "Week Ending" at the beginning of the time period it's making it so the dates are being read as text and not actual dates?
Bookmarks