If you are asking how can you sort on a field that is not in the pivot table,
you can't.

Of course you could sort on it and then hide that column of the spreadsheet.

My question - if the field doesn't show who will know that the pivot table
isn't sorted by that field? In other words, I'm not sure of why you would do
this?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Marc" wrote:

When I create a Pivot Table with a list of about 10 suppliers. Why does the
feild I unselect disapear from the Pivot Table? If I want to view the suplier
I have unselected I need to add it back to the table. I want to avoid doing
this. Any ideas?