| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort Columns in Pivot Tables
Thanks Dave. Works fine now. Appreciate the help.
"Dave Peterson" wrote: Maybe you can change the labels to make it easier to sort 00-04 05-07 07-10 10-12 12-99 Another option that worked for me under light testing... Tools|Options|Custom lists I added the list in the order that I wanted and my newly created pivottable came out in that order. les8 wrote: I have a pivot table that has columns "<5", "5-7", "7-10", "10-12" and "12". However, when the pivot table comes up, they are out of order (<5, 12, 10-12, 5-7, 7-10). I can manually rearrange the columns using the order option, but is there any way to get them to come out in the correct order? Thanks very much for your help. -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| How do I sort the data in 8 columns by two of the columns? | Excel Worksheet Functions | |||
| Sort in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Tables | Excel Worksheet Functions | |||
| combining 3 columns of same info for a pivot table | Excel Worksheet Functions | |||
Threaded Mode
