| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table
When i generate a pivot table the months order changes , Example below does
anyone know how to amend this Month Total Apr-08 0 Aug-07 0 Aug-08 0 Dec-07 0 Feb-08 0 Jan-08 1 Jul-08 0 Jun-08 0 Mar-08 0 May-08 0 Nov-07 0 Oct-07 0 Sep-07 0 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table
It looks like your 'dates' are formatted as text. Try formatting the dates
in the original data list as mmm-yy (you'll probably have to press F2 followed by Enter on each date cell to make them convert properly from text format). Andrea Jones www.stratatraining.co.uk "MillyD" wrote: When i generate a pivot table the months order changes , Example below does anyone know how to amend this Month Total Apr-08 0 Aug-07 0 Aug-08 0 Dec-07 0 Feb-08 0 Jan-08 1 Jul-08 0 Jun-08 0 Mar-08 0 May-08 0 Nov-07 0 Oct-07 0 Sep-07 0 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table
just tried that ,,,,, and its still generate the same list
Never mind Cheers anyway "Andrea Jones" wrote in message ... It looks like your 'dates' are formatted as text. Try formatting the dates in the original data list as mmm-yy (you'll probably have to press F2 followed by Enter on each date cell to make them convert properly from text format). Andrea Jones www.stratatraining.co.uk "MillyD" wrote: When i generate a pivot table the months order changes , Example below does anyone know how to amend this Month Total Apr-08 0 Aug-07 0 Aug-08 0 Dec-07 0 Feb-08 0 Jan-08 1 Jul-08 0 Jun-08 0 Mar-08 0 May-08 0 Nov-07 0 Oct-07 0 Sep-07 0 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table
Hi Milly
You are doing an ascending sort on Month. You need to Create a Custom list of dates for it to use ToolsOptionsCustom Listscreate a list Aug 07 Sep 07 Oct 07 .. .. Jul 09 Go back to your PTDouble click on Month fieldAdvancedSortOKOK -- Regards Roger Govier "MillyD" wrote in message ... just tried that ,,,,, and its still generate the same list Never mind Cheers anyway "Andrea Jones" wrote in message ... It looks like your 'dates' are formatted as text. Try formatting the dates in the original data list as mmm-yy (you'll probably have to press F2 followed by Enter on each date cell to make them convert properly from text format). Andrea Jones www.stratatraining.co.uk "MillyD" wrote: When i generate a pivot table the months order changes , Example below does anyone know how to amend this Month Total Apr-08 0 Aug-07 0 Aug-08 0 Dec-07 0 Feb-08 0 Jan-08 1 Jul-08 0 Jun-08 0 Mar-08 0 May-08 0 Nov-07 0 Oct-07 0 Sep-07 0 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Hybrid Mode
