Excel 2002 - Pivot Table : How to rearranged columns by draging ?

G

Guest

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
 
R

Roger Govier

Hi Low

To eliminate the Grand Totals, right click on PT>Table Options>uncheck Gran
Total by Row and Grand Total by Column

To change the order of your columns, right click on a column field in the
PT>Order>Move 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top