Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |