Pivot Table Sort Order

M

Mustang

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
 
M

Martin Fishlock

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.
 

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

Excel Pivot Table - Sort Report Filter Values 3
how do I control the sort order of a filter in a pivot table? 1
Pivot Table sorting 1
Pivot Table Data Column Sort Excel 2007 1
pivot table - drop down filter box has 10% of items out of order 2
Pivot Table Items 3
Excel 2002 - Pivot Table : How to rearranged columns by draging ? 2
Pivot Table sort -Excel 2007 4

Top