Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting sub groups in pivot tables | Excel Discussion (Misc queries) | |||
Sorting in Pivot Tables | Charts and Charting in Excel | |||
Pivot Tables - sorting numbers | Excel Discussion (Misc queries) | |||
Sorting in pivot tables | Excel Discussion (Misc queries) | |||
Sorting data in Pivot Tables | Excel Discussion (Misc queries) |