Pivot Table Month Order

  • Follow


The month order as a column heading is in the correct order except that Sep 
is at the very end rather than after Aug.  I'm new at working with pivot 
tables and have been unsuccessful in researching and correcting the problem.

Thanks.
0
Reply Utf 1/2/2010 6:48:01 PM

The problem is you are using month names, which Excel, naturally sorts into 
alphabetical order. Your choices are:

1. Use month numbers -- at least they will sort properly.
2. Use the full date, which you can format to display just the month name. 
You the display that you want. and your results will be sorted properly.

Regards,
Fred

"drangonfly2664" <drangonfly2664@discussions.microsoft.com> wrote in message 
news:B4F51A46-EB65-4438-B3A0-2E0D2A148AF5@microsoft.com...
> The month order as a column heading is in the correct order except that 
> Sep
> is at the very end rather than after Aug.  I'm new at working with pivot
> tables and have been unsuccessful in researching and correcting the 
> problem.
>
> Thanks. 

0
Reply Fred 1/2/2010 9:33:40 PM


Alternatively, Tools>Options>Custom Lists and create a list of Months in the 
order you want them.
Then set the Pt to Sort Ascending on Month and it will use the Custom List 
order.

-- 
Regards
Roger Govier

"Fred Smith" <fsmith11@yahooo.com> wrote in message 
news:extRBN$iKHA.1420@TK2MSFTNGP05.phx.gbl...
> The problem is you are using month names, which Excel, naturally sorts 
> into alphabetical order. Your choices are:
>
> 1. Use month numbers -- at least they will sort properly.
> 2. Use the full date, which you can format to display just the month name. 
> You the display that you want. and your results will be sorted properly.
>
> Regards,
> Fred
>
> "drangonfly2664" <drangonfly2664@discussions.microsoft.com> wrote in 
> message news:B4F51A46-EB65-4438-B3A0-2E0D2A148AF5@microsoft.com...
>> The month order as a column heading is in the correct order except that 
>> Sep
>> is at the very end rather than after Aug.  I'm new at working with pivot
>> tables and have been unsuccessful in researching and correcting the 
>> problem.
>>
>> Thanks.
>
>
> __________ Information from ESET Smart Security, version of virus 
> signature database 4738 (20100102) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
> 

__________ Information from ESET Smart Security, version of virus signature database 4738 (20100102) __________

The message was checked by ESET Smart Security.

http://www.eset.com



0
Reply Roger 1/2/2010 11:16:03 PM

2 Replies
776 Views

(page loaded in 3.105 seconds)


Reply: