Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Disappearing Data Items on Pivot Table -Updated Question
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
The expert in this area is Debra Dalgleish and she has information on this
on her site at http://www.contextures.com/xlPivot12.html -- Regards Roger Govier "GeorgeChe" wrote in message ... 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 |
#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 |
Reply |
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) |