Pivot Tables
 

I have a source sheet that has several columns in it (see below). The column
for RC can have a number in it from 0-23. When I create a pivot table with
this data (see below), it throws RC in whatever order it wants. I would like
the legend to read in numeric order. Any help on how to make the legen sort?

Columns in worksheet-
DEPT, WEEK, DAY, MONTH, CLIENT NAME, CLIENT #, DATE, OP, FILE, RC, REASON
DESC.

PIVOT TABLE
Page Field is DEPT
Row Field is OP
Column Field is RC
Data Item is File

Pivot Tables
 

Double-click the RC button in the Column area.
Click the Advanced button
Under AutoSort, click on Ascending, then click OK.

Dustin B wrote:
I have a source sheet that has several columns in it (see below). The column
for RC can have a number in it from 0-23. When I create a pivot table with
this data (see below), it throws RC in whatever order it wants. I would like
the legend to read in numeric order. Any help on how to make the legen sort?

Columns in worksheet-
DEPT, WEEK, DAY, MONTH, CLIENT NAME, CLIENT #, DATE, OP, FILE, RC, REASON
DESC.

PIVOT TABLE
Page Field is DEPT
Row Field is OP
Column Field is RC
Data Item is File



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html