Excel 2002: Can I sort columns of the Pivot Table ? in Excel General Questions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
Mr. Low 10/5/2007 6:11 AM PST
  Question
  Dear Sir,

I have generated the following Pivot Table by default:

Month
5 6 7 8 9 Total
Code xxxx xxxx xxx
xxxx
L261
K921
T421
Q488
P123
G.Total xxxx xxxxx
xxxxx


If I wish to have the month in descending order of 9,8,7,6 and 5, may I know
how to reset or sort the column ?


Thanks

Low



--
A36B58K641
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Roger Govier 10/5/2007 7:25 AM PST
  Answer
  Hi

Double click on the Month field in the PT.
Advanced>Autosort options>Descending>OK>OK

--
Regards
Roger Govier



"Mr. Low" <lsk2141@discussions.microsoft.com> wrote in message
news:586DD33A-5EEC-4B8A-B659-C1425BCBC3B4@microsoft.com...
> Dear Sir,
>
> I have generated the following Pivot Table by default:
>
> Month
> 5 6 7 8 9 Total
> Code xxxx xxxx xxx
> xxxx
> L261
> K921
> T421
> Q488
> P123
> G.Total xxxx xxxxx
> xxxxx
>
>
> If I wish to have the month in descending order of 9,8,7,6 and 5, may I
> know
> how to reset or sort the column ?
>
>
> Thanks
>
> Low
>
>
>
> --
> A36B58K641


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Mr. Low 10/5/2007 4:40 PM PST
   
  Hello Roger,

Thanks for your tip.

Low

--
A36B58K641


"Roger Govier" wrote:

> Hi
>
> Double click on the Month field in the PT.
> Advanced>Autosort options>Descending>OK>OK
>
> --
> Regards
> Roger Govier
>
>
>
> "Mr. Low" <lsk2141@discussions.microsoft.com> wrote in message
> news:586DD33A-5EEC-4B8A-B659-C1425BCBC3B4@microsoft.com...
> > Dear Sir,
> >
> > I have generated the following Pivot Table by default:
> >
> > Month
> > 5 6 7 8 9 Total
> > Code xxxx xxxx xxx
> > xxxx
> > L261
> > K921
> > T421
> > Q488
> > P123
> > G.Total xxxx xxxxx
> > xxxxx
> >
> >
> > If I wish to have the month in descending order of 9,8,7,6 and 5, may I
> > know
> > how to reset or sort the column ?
> >
> >
> > Thanks
> >
> > Low
> >
> >
> >
> > --
> > A36B58K641
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies