Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Can I sort columns of the Pivot Table ?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Can I sort columns of the Pivot Table ?
Hi
Double click on the Month field in the PT. AdvancedAutosort optionsDescendingOKOK -- Regards Roger Govier "Mr. Low" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Can I sort columns of the Pivot Table ?
Hello Roger,
Thanks for your tip. Low -- A36B58K641 "Roger Govier" wrote: Hi Double click on the Month field in the PT. AdvancedAutosort optionsDescendingOKOK -- Regards Roger Govier "Mr. Low" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort a Piviot table by the Total field in Excel 2002 | Charts and Charting in Excel | |||
Excel 2002 - Pivot Table : Can I divide instead of sum ? | Excel Discussion (Misc queries) | |||
Excel 2002 Pivot Table Date | Excel Worksheet Functions | |||
Excel 2002 Pivot Table Protection | Excel Discussion (Misc queries) | |||
Pivot Table in Excel 2002 | Excel Discussion (Misc queries) |