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
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