| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting in Excel 2000 Pivot Tables
In an Excel 200 Pivot Table I have a column of text data which appears as
follows: P1-10, P1-2, P1-20, P1-5. Is there anyway I can re-sort this data so that it appears as follows: P1-2, P1-5, P1-10, P1-20. Thx, -- LPS |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting in Excel 2000 Pivot Tables
How about change the underlying data to look more like:
p1-02 p1-05 p1-10 p1-20 Then your sorting will become much easier. LPS wrote: In an Excel 200 Pivot Table I have a column of text data which appears as follows: P1-10, P1-2, P1-20, P1-5. Is there anyway I can re-sort this data so that it appears as follows: P1-2, P1-5, P1-10, P1-20. Thx, -- LPS -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Pivot Table Refresh Question | Excel Discussion (Misc queries) | |||
| sorting problem in excel 2000 | Excel Discussion (Misc queries) | |||
| Pivot Tables - Using Excel 2003 & Windows XP Pro... | Excel Discussion (Misc queries) | |||
| Large Excel file size, no pivot tables | Excel Discussion (Misc queries) | |||
| How can I change the default settings for pivot tables in Excel? . | Excel Discussion (Misc queries) | |||
Linear Mode
