Pivot Table Sort

[filky]

I have created a Pivot table grouping dates by month. The result i
similar to;

Jan 06
Feb 06
Mar
Jun 05
Jul 05
Aug 05
Sep 05
Oct 05
Nov 05
Dec 05

How do I force it to sort so that the Jan 06 and the Feb 06 appear a
the bottom of the list?

Thanks

Paul

 

[Guest]

One way is to create a custome sort list:
Tools
Options
Custom Lists
In the "list entry Box" type in the order you want the data sorted (enter
after each line)
Click add

Once the list is added:
Click on any value in the pivot table
Data
Sort
Options
Select your newly created sort list
OK
OK

especially useful if you'll use the sortation frequently.

Hope this helps - Kim

 

[VancitysFinest]

In the cell with "Dec 05", type in "Feb 06". This should slide the
other months over one cell to the left.
"Dec 05" should now be to the left of "Feb 06", so type "Jan 06" in its
place.

You can type any values in the headings, and Excel will group the data
under the matching headings.

~ Victor Lai

 

[vezerid]

Paul,

use an extra column in your original data with the formula (assuming
month in G:G):

=DATEVALUE("1 "&G2)

Menu Format|Cells...|Number tab, Date or Custom format as "mmm yy"

You can then base your PT on the new column.

HTH
Kostis Vezerides

 

[filky]

Thank you all. I used the Custom Sort List and it worked well.
useful facility I didn't know was there.

Thanks again

Paul