Pivot Table Sort

B

Bob

I am using Excel 2000. I have created a simple list
containing "Contract #'s", "Beginning Dates","Ending
Dates","Terms (in Months)", and "Contract Value". I
created a pivot table based on the above. When I try to
sort the PT by "Ending Date" or "Beginning Date". nothing
happens. The only column (non-value) I can sort is the
first column "Contract #". I have eliminate all auto sorts
from the PT. Everything is set to Manual. Is there
something I'm missing ?

I appreciate your help as always.
 
D

Debra Dalgleish

You should be able to click on a field button, then click a Sort button
(A-Z or Z-A) in the toolbar, to sort the items in that field.

If there are multiple fields in the row or column area, and you sort an
inner field, it will sort the items under each outer field. For example,
if you have Terms and Beginning Dates in the Row area, and sort by Date,
the Dates under each Term will be sorted.
 
B

Bob

Debra, thank you for your input, unfortunatley, this does
not seem to fix my problem. My PT is as follow;

Contract # - Beg Date - End Date - Terms - Contract Value
Label - Label - Label - Label - Value

When I click on the filed heading "End Date" and to to the
tool bar and select <Data/Sort>, the PT remains sorted in
ascending order by "Contract #". I can't figure this one
out.

Would appreciate any other assistance/sugestions you can
offer.

Thanks again.
Bob
 
B

Bob

Debra, thank you for your input, unfortunatley, this does
not seem to fix my problem. My PT is as follow;

Contract # - Beg Date - End Date - Terms - Contract Value
Label - Label - Label - Label - Value

When I click on the field heading "End Date" and to to the
tool bar and select <Data/Sort>, the PT remains sorted in
ascending order by "Contract #". I can't figure this one
out.

Would appreciate any other assistance/sugestions you can
offer.

Thanks again.
Bob
 
D

Debra Dalgleish

The pivot table will always be sorted from the outer fields to the inner
fields. If you want to sort first by End Date, move it to the left of
Contract#.
 
Top