Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |