sorting in Pivot tables
 

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

sorting in Pivot tables
 

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


"Ben" wrote:

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

sorting in Pivot tables
 

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.

--
Regards,
Tom Ogilvy


Ben wrote in message
...
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