| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting in a Pivot Table unselected fields
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting in a Pivot Table unselected fields
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem inserting calculated pivot fields into Pivot Table (2007) | Excel Discussion (Misc queries) | |||
| Problem with multiple sorting of fields in Pivot table | Excel Discussion (Misc queries) | |||
| Sorting multiple columns (fields) in a pivot table | Excel Discussion (Misc queries) | |||
| fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
| number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
