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

"filky" wrote:


I have created a Pivot table grouping dates by month. The result is
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 at
the bottom of the list?

Thanks

Paul.


--
filky
------------------------------------------------------------------------
filky's Profile: http://www.excelforum.com/member.php...o&userid=11801
View this thread: http://www.excelforum.com/showthread...hreadid=506484