Excel 2002: How to sort row totals in Pivot Table ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear Sir,

I have a pivot table below :

A B C D E
F

1 Sum of amount Month
2 Code Customer Jan07 Feb07 Mar07 Total
3 L121 xxx
4 P252 xxx
5 S178 xxx
6 G.Total xxx


May I know how to sort the total in column F in ascending or descending
order ?

I try to highlight the table and use Data > Sort > $F3 > Values > Ascending
but it does not work.


Thanks

Low
 
You should double click in the Pivot table field, where you have the title of
your pivot table, then go to advance, and then autosort options
 
Hi

First
Tools>Options>Custom Lists> create a list of Jan-07, Feb-07 etc.
Then
As advised before, double click Field>Advanced>sort>Ascending
 
Mr. Low said:
Dear Sir,

I have a pivot table below :

A B C D E
F

1 Sum of amount Month
2 Code Customer Jan07 Feb07 Mar07 Total
3 L121 xxx
4 P252 xxx
5 S178 xxx
6 G.Total xxx


May I know how to sort the total in column F in ascending or descending
order ?

I try to highlight the table and use Data > Sort > $F3 > Values > Ascending
but it does not work.


Thanks

Low
Click to expand...
 

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

Similar Threads

Excel 2002: Can I sort columns of the Pivot Table ? 2
Excel 2002 Worksheet: Can I sort the columns ? 3
Pivot Table 5
Excel 2002 - Pivot Table : How to rearranged columns by draging ? 2
Excel 2002: Can Pivot Table show headings beside the row labels ? 2
Sort in a Pivot Table 1
Excel 2002 Pivot Table: Can I use it for transposing data ? 6
Excel 2002:How to remove sub total rows in Pivot Table ? 2

Back
Top