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