| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort pivot table field (droplist) by month or original data
Excel 2007
Pivot Table will not sort correctly if some months are fully spelled out (December) and others are not (Sept). Once all the months are in the same format as in the Built-in Lists, sorting should be automatic. For other data, sorting the field will also sort the drop down list. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Sort Field Help | Excel Discussion (Misc queries) | |||
| Convert date field to month in Pivot table | Excel Discussion (Misc queries) | |||
| Sort Pivot Table using hidden data field | Excel Discussion (Misc queries) | |||
| Calculated Pivot table field on YTD £(subract Mar-feb)=month | Excel Worksheet Functions | |||
| How do I restore original Pivot Table data? | Excel Discussion (Misc queries) | |||
Threaded Mode
