| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort pivot table field (droplist) by month or original data
I have a pivot table of which I updated with additional info...
WHen I updated it, the months (starting with June, July, August, Sept, etc) were rearranged and is now out of order on my drop down list (filter) on the pivot table. Is there any way to get this back to the same order that the original data is in, or correct subsequential month order? Reads Should Read June June July July Sept August August Sept October October December December |
| 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
