Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to sort row totals in Pivot Table ?
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 -- A36B58K641 |
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) | |||
How do I sort a Piviot table by the Total field in Excel 2002 | Charts and Charting in Excel | |||
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) |