sorting in Pivot tables

[Ben]

Hi all,

I have a pivot table, which contains consultant names and numbers in the
row, month in the column and cost in the data. I use the pivot table to
see how much we spend on each consultant each month. The Grant Total column
shows the YTD dollar amount spent on each.

But what I like to do is sort Grant Total dollar amount by decending order,
ie, the highest first. But Excel 97 does not allow me. Any suggstions?
Thanks.

Ben

 

[keepitcool]

Ben,

rightclick field
select field settings
click advanced
you'll find the sorting options.


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Tom Ogilvy]

If I was doing it for myself, I would select all the cells in the sheet, do
edit=>Copy, edit=>PasteSpecial =>Values.

Now it is no longer a pivot table. I would select the data and do a sort on
the Grant Total column, descending.

If you want to retain your pivot table, then select the sheet tab, hold down
the ctrl key and drag to the right to create a copy - do the work on the
copy.