| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Thanks again Roger. I now know what to do
"GeorgeChe" wrote: Thanks Roger. Following on from your response, Is it possible to fix data field so that it can not be de-selected? Thanks George "Roger Govier" wrote: De-selecting a Data field always removes that field from the Pivot table. It assumes you no longer wish to aggregate that data. Selecting or De-selecting Rows or Columns (or Pages) is merely changing the view of the data that has been aggregated. -- Regards Roger Govier "GeorgeChe" wrote in message ... I have just created a pivot table with two column fields, 1 row field and six data fields. I can select on the column and row fields but when i try to select items on the data field, the unselected items disappear when i go back into drop down menu on data field to make another selection. The only way to get it back is to add the field to the data. Is there a way of fixing the fields in data. Yours desperately George |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to clear data references in pivot table report | Charts and Charting in Excel | |||
| How do I get a pivot table to sort based on the data items sectio. | Excel Worksheet Functions | |||
| How do I remove items listed in a pivot table drop down list box | Excel Discussion (Misc queries) | |||
| Pivot Table Data | Excel Worksheet Functions | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Threaded Mode
