Thread: Order column in pivot table.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
  
Posts: 2,824
Default Order column in pivot table.
Try rightclicking on the column heading (in the pivottable).
Select Field Settings
Click on Advanced
And choose your sort order there.

John wrote:

Is it possible to force the order of the column headings in a pivot table of multiple selections.
The heading i have are like 200402, 200403 etc. Each month I have a new column and its not sorting. i.e 200403, 200402, 200404 etc.

Any ideas appreciated.

John

--

Dave Peterson

Reply With QuoteReply With Quote