| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort by month on pivot report
I have a pivot report where customers are listed alphabetically in rows, and
the columns are sorted alphabetically, too. Trouble is, the columns are months, and I want to sort Jan, Feb, etc, but it's sorting alphabeticcally. The column headings come from a datamart list and are : Apr 05, Aug 05, and so on on. Is it the "05" that won't let me sort by month? Any work arounds? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Pivot Table - Sort Report Filter Values | Excel Discussion (Misc queries) | |||
| YTD value minus prev mth value = curent month - Rolling Report | Excel Worksheet Functions | |||
| Pivot table aging report sort order | Excel Worksheet Functions | |||
| How do I change a pivot table report to sort when I drill down | Excel Worksheet Functions | |||
| urgent pls! sort date pivot report | Excel Discussion (Misc queries) | |||
Threaded Mode
