Sorting in a Pivot Table unselected fields

M

Marc

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

Shane Devenshire

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

grouping dates in a pivot table 1
Average of Subtotals in Pivot Table 0
Size of file with pivot table 2
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table 3
Pre-configuring Pivot table "views" 4
Sorting the pivot table field list 4
N/A in pivot table become 0 1

Top