Hello:

I'm trying to sort pivot table by year but it doesn't seem to recognize it
as a date format. The results show YYYY for anything prior or after current
year and for current year it also includes quarter (i.e. 2009 Q1, 2009 Q2,
etc...). When I sort it puts the current year at the bottom but I need it to
be btw 2008 and 2010.
Any help would be appreciated.
Thank you.
Monika

Here is what the pivot looks like after I sort:
RSDD Qtr CT MR NUC RAD Grand Total
2014 1200 1200
2019 12000 12000
2009 Q1 1500 1500
2009 Q2 900 900
2009 Q3 1200 1200
2009 Q4 450 450
No Dates 120 120
39953 120 120
39984 240 240
40014 300 300
40045 1200 1200
40106 3000 3000
Grand Total 13440 5340 750 2700 22230