Pivot Tables

D

Dustin B

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
 
D

Debra Dalgleish

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA- IF statement to replace cell contents 0
Macro - Formula RC[?] with ? being a variable number 5
VBA Pivot Table help with data fields 3
Using text values in Pivot Tables 5
Sort in Pivot Table 1
Limited Pivot Tbl Row and Column Fields 4
Access VBA error "Microsoft Access can't find the field '|' referred to in your experssion" 0
Access VBA error "Microsoft Access can't find the field '|' referred to in your experssion" 0

Top