Pivot Table Question

Mar 6th, 2002, 09:49 AM

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. · Mar 6th, 2002, 10:57 AM

See http://www.mrexcel.com/board/viewtop...1450&forum=2&3

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 09:49 AM	#1
Guest Posts: n/a	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

Mar 6th, 2002, 10:57 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	See http://www.mrexcel.com/board/viewtop...1450&forum=2&3