No, the outer column field can't be ignored to sort by the the second
column. You'll have to move workstation location to the left if you want
to sort by that.

Natalie wrote:
Hi, I have a pivot table with multiple column fields: Part number, warehouse
location, workstation location. I would like to display the fields in the
order shown above (from left to right) but would like to sort the data by
workstation location. Is there any function that can help me sort in this
way? I tried the sort function but it only sorts the first column. I'm
using Excel 2007.

Would appreciate any help.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html