I have dates, and a number corresponding on those dates. I want to try and find the average number for each quarter, so I created a pivot table. My problem is that the pivot table is ordered by the first digit, instead of chronologically and I cant seem to fix this. The sort option doesn't help.
In short what I want to accomplish:
1. Order dates chronologically in the pivot table
2. Group dates by quarter
3. Find the average rate for each quarter
Using this excel sheet: