G
Guest
Guest
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
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
