Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort Pivot by Year
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort by date but not year | Excel Discussion (Misc queries) | |||
Sort by week and year | Excel Worksheet Functions | |||
Sort by Year and Week | Excel Worksheet Functions | |||
Sort by Month and Year | Excel Discussion (Misc queries) | |||
How do I sort dates by month rather than by year? | Excel Discussion (Misc queries) |