Pivot table sorting problem

S

Stevie

Hi everybody,

I have a question about a pivot table. I created one, with numbered
items.
It's something like
1. chapter 1
2. chapter 2
..........
11. chapter 11

The thing is I get the sort by 1, 11, 2, 21, 3 ... in my pivot table.
I tried changing the sort order to ascending as well as to descending
to no avail.

What else could I try to make the sort make some sense? I want to end
up 1, 2, 3, ... , 11, ... , 21 ... ; like from 1 to for example 100.

Thanks in advance.

Stevie.
 
F

Frank Kabel

Hi Stevie
I would use a helper column which contains only your chapter number as
numeric value
 
D

Debra Dalgleish

You can create a custom sort order:

In a cell on a blank worksheet, type Chapter 1
Select the cell, and point to the fill handle (the small
black square at the bottom right of the selection)
Drag down, to create a numbered list of chapters
(drag down to create as many as you need)
Select the list of chapters
Choose Tools>Options
Select the Custom Lists tab
Click the Import button, click OK

When you create a new pivot table, chapters will be in the order of the
custom list.

To sort the chapters in an existing pivot table, select a cell in the
chapters column, and click the A-Z button on the toolbar.
 
Top