Is this possible? I'm starting with a pivot table with 2 data fields (Sales
and %Change). I have the data sorted by Sales, which is what I want. I
don't, however, want the Sales field to be displayed. When I hide the Sales
field, my sorting goes away. After further experimentation, I've found that
hiding a data field is nothing more than removing it from the pivot table.
Is there a way that I can only display %Change, but have my data sorted by
Sales?

Thanks!

Jeff