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.