Thread: Pivot Tables
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dustin B Dustin B is offline
external usenet poster
 
Posts: 10
Default 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