Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Sort Order
Hi,
I am using Excel 2003 and have three types of Work in my Pivot Table: Erect Alter Dismantle This work type is my outer row in my pivot table but it is sorted in alphabetical order. I would like my data to be sorted as above. I know that I can drag them around but I have a macro that updates the Pivot Table based on an Advanced Filter. Is there anyway I can fix in place the non alphabetical sort order? Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Sort Order
Hi,
Apart from the manual drag and drop there is no automatic method that I know of. There are a couple of quick fixes. 1. Add another column with 1,2,3 with a vlookup to get the order and include that in the table. 2. Modify the words to 1. Erect 2. Alter 3. Dismantle And then this will sort. -- Hope this helps Martin Fishlock, www.nyfconsultants.com, Wolverhampton, UK Please do not forget to rate this reply. "Mustang" wrote: Hi, I am using Excel 2003 and have three types of Work in my Pivot Table: Erect Alter Dismantle This work type is my outer row in my pivot table but it is sorted in alphabetical order. I would like my data to be sorted as above. I know that I can drag them around but I have a macro that updates the Pivot Table based on an Advanced Filter. Is there anyway I can fix in place the non alphabetical sort order? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I control the sort order of a filter in a pivot table? | Excel Discussion (Misc queries) | |||
sort order of pivot table drill down | Excel Discussion (Misc queries) | |||
Pivot table sort order | Excel Worksheet Functions | |||
Sort order not being matched in pivot table | Excel Discussion (Misc queries) | |||
Pivot table sort order | Excel Discussion (Misc queries) |