View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gimpy815 Gimpy815 is offline
external usenet poster
 
Posts: 5
Default sort by month on pivot report

Roger-

Worked like a charm! Most grateful!

"Roger Govier" wrote:

Hi

ToolsOptionsCustom Listscreate a list in the white pane of Jan 05, Feb 05
....... Dec 05Add
continue the series through 06 and 07 if required.

On the PT, double click on the filed headingadvancedAutosortAscending
--
Regards
Roger Govier



"Gimpy815" wrote in message
...
I have a pivot report where customers are listed alphabetically in rows,
and
the columns are sorted alphabetically, too. Trouble is, the columns are
months, and I want to sort Jan, Feb, etc, but it's sorting
alphabeticcally.
The column headings come from a datamart list and are : Apr 05, Aug 05,
and
so on on. Is it the "05" that won't let me sort by month? Any work
arounds?