View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ben[_5_] Ben[_5_] is offline
external usenet poster
 
Posts: 5
Default 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