sorting in Pivot tables

  • Thread starter Thread starter Ben
  • Start date Start date
B

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
 
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.
 
Back
Top