| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove a Calculated Field from the Pivot Table field list
I have created two fields in my Pivot Table. However, the first one had an
error in it. I tried to modify it, but was unsuccessful. So, I just did it again. This means not only creating a new name, the original field stays in the Field List. So, I guess my post has two questions. How do you modify a Field? and How do you remove a Field? -- TheTraveler |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I remove a Calculated Field from the Pivot Table fieldlist
Hi
Second part first Select the field first from the dropdownclick Modify To get rid of a field, select the field from the dropdownDelete -- Regards Roger Govier TheTraveler wrote: I have created two fields in my Pivot Table. However, the first one had an error in it. I tried to modify it, but was unsuccessful. So, I just did it again. This means not only creating a new name, the original field stays in the Field List. So, I guess my post has two questions. How do you modify a Field? and How do you remove a Field? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I remove a Calculated Field from the Pivot Table field
Roger....
That is exactly what I needed. I feel stupid for not having looked around when I was in there. I have modified the original and removed the duplicate. I am a happy camper. -- TheTraveler "Roger Govier" wrote: Hi Second part first Select the field first from the dropdownclick Modify To get rid of a field, select the field from the dropdownDelete -- Regards Roger Govier TheTraveler wrote: I have created two fields in my Pivot Table. However, the first one had an error in it. I tried to modify it, but was unsuccessful. So, I just did it again. This means not only creating a new name, the original field stays in the Field List. So, I guess my post has two questions. How do you modify a Field? and How do you remove a Field? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table, IF function, calculated item versus calculated field | Excel Discussion (Misc queries) | |||
| Creating a Calculated Field in a Pivot Table for same field | Excel Discussion (Misc queries) | |||
| remove a calculated field from a pivot table in Excel 2003 | Excel Discussion (Misc queries) | |||
| How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
Linear Mode
