Sorting a Pivot Table
 

I have a pivot table that I need to sort the contents of, by the last data
column. I've tried help, but am just not able to get there. Does anyone
have a helpful hint? I am on 2003 and following are the fields of my table.

Sum of AccountCommission
C.Client.Code C.Client Name.......................... Eff.Date Total

Am trying to sort by Total (sum of accountcommission)

Thank you

Cathy

Sorting a Pivot Table
 

Click on the far left field in the pivot table, on the toolbar, click "Pivot
Table." Click "Sort and Top 10." Click "Descending" radio button and then
under "using field" select account commission. (For highest to lowest,
otherwise change radio button to ascending)

You need to have the Pivot Table on the toolbar for this. If not, go to
View, Toolbars, and select Pivot Table.


"cware" wrote:

I have a pivot table that I need to sort the contents of, by the last data
column. I've tried help, but am just not able to get there. Does anyone
have a helpful hint? I am on 2003 and following are the fields of my table.

Sum of AccountCommission
C.Client.Code C.Client Name.......................... Eff.Date Total

Am trying to sort by Total (sum of accountcommission)

Thank you

Cathy

Sorting a Pivot Table
 

Because you have two fields in the row area, the Sum Of Account
Commission will sort within each Client Code, not over the entire column
of totals.

You could add a column in your source and combine the client code and
client name fields. For example:
=A2 & " - " & B2

Then, remove the client code and client name fields from the pivot
table, and add new field instead. Then you should be able to sort on the
Total column.

cware wrote:
I have a pivot table that I need to sort the contents of, by the last data
column. I've tried help, but am just not able to get there. Does anyone
have a helpful hint? I am on 2003 and following are the fields of my table.

Sum of AccountCommission
C.Client.Code C.Client Name.......................... Eff.Date Total

Am trying to sort by Total (sum of accountcommission)

Thank you

Cathy



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com