Pivot Table question - again - signed it this time

[Paul-Johnson]

Is there us a way to sort the columns in a pivot table ?

Below is a simple example (my real data is much more complex)

Cat <100
Mouse <100
Dog 100-500
Rabbit 501-1000
Hamster 501-1000
Elephant > 1000
Giraffe > 1000

When I create the pivot table

The rows are the animals listed, the columns are the values listed, and the data is the count of each value.

Unfortunately, the columns come out in the following order:
> 1000
100-500
501-1000
< 100

Is there a way to change the order in which they appear, other than changing the source data ? In reality there are 30,000 + items.

Your help is appreciated.

PJ

 

[Mark W.]

Yes, just drag the COLUMN field items and place them in the desired order.

 

[Paul-Johnson]

That does not work, as they are all in the under the same column field

 

[Mark W.]

Click on each Item in your PivotTable, grab hold of its column boundary, and drag it to the desired position.

 

[Guest]

Maybe I am being dumb. But, when i try select the column of data and try to move it via the handlebars, i get an error message saying that operation cannot be performed.

 

[Mark W.]

Ahh, now I understand your problem. There shouldn't be a fill handle after you make the proper selection. Evidently, the Enable Selection mode has been disabled. Right click on your PivotTable and choose the Select | Enable Selection popup menu command. The icon should appear depressed (but, not in need of Prozac , Sorry...). Once done you can click on a column field item and the entire column (label and data values) will be selected. Drag these cells by their border to the desired position.

BTW, there is another approach... creating a custom sort order list... but, this list would only reside on your PC and not "travel" with the workbook which could lead to a configuration issue later. That's why I didn't mention it previously.
This message was edited by Mark W. on 2002-03-06 10:36

 

[Paul-Johnson]

Got it --- My enable button was depressed

My problem was i was grabbing the handlebar instead of the boundary (if that makes sense).

Thanks Again !!!!

I am interested in the custom sort - I will research it. Thanks Again !
_________________
Paul
This message was edited by Paul-Johnson on 2002-03-06 10:36