Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 - Pivot Table : How to rearranged columns by draging ?
Dear Sir ,
I have the following Pivot Table : Sum of Amt Column Label Row Label Claim Collectable Dispute Outstanding Grand Total A921 xxx B841 xxx D147 E465 P544 Grand Total By default the column is sorted in alphabetical order, may I know how to drag the column to the order I wanted ? I try but the column does not move. Also can you show me how to eliminate row and column total if they are not needed ? Thanks Low -- A36B58K641 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 - Pivot Table : How to rearranged columns by draging ?
Hi Low
To eliminate the Grand Totals, right click on PTTable Optionsuncheck Gran Total by Row and Grand Total by Column To change the order of your columns, right click on a column field in the PTOrderMove Left (or Right) It will only move one column at a time (unless you choose Move to Beginning or End) so you may need to repeat the process several times. -- Regards Roger Govier "Mr. Low" wrote in message ... Dear Sir , I have the following Pivot Table : Sum of Amt Column Label Row Label Claim Collectable Dispute Outstanding Grand Total A921 xxx B841 xxx D147 E465 P544 Grand Total By default the column is sorted in alphabetical order, may I know how to drag the column to the order I wanted ? I try but the column does not move. Also can you show me how to eliminate row and column total if they are not needed ? Thanks Low -- A36B58K641 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 - Pivot Table : How to rearranged columns by dragin
Hello Roger,
Thanks for the tips. It works well. Kind Regards Low -- A36B58K641 "Roger Govier" wrote: Hi Low To eliminate the Grand Totals, right click on PTTable Optionsuncheck Gran Total by Row and Grand Total by Column To change the order of your columns, right click on a column field in the PTOrderMove Left (or Right) It will only move one column at a time (unless you choose Move to Beginning or End) so you may need to repeat the process several times. -- Regards Roger Govier "Mr. Low" wrote in message ... Dear Sir , I have the following Pivot Table : Sum of Amt Column Label Row Label Claim Collectable Dispute Outstanding Grand Total A921 xxx B841 xxx D147 E465 P544 Grand Total By default the column is sorted in alphabetical order, may I know how to drag the column to the order I wanted ? I try but the column does not move. Also can you show me how to eliminate row and column total if they are not needed ? Thanks Low -- A36B58K641 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Can I sort columns of the Pivot Table ? | Excel Discussion (Misc queries) | |||
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) |