Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 376
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table, IF function, calculated item versus calculated field NomadPurple Excel Discussion (Misc queries) 1 March 9th 10 04:17 PM
Creating a Calculated Field in a Pivot Table for same field dza7 Excel Discussion (Misc queries) 3 October 21st 09 11:22 PM
remove a calculated field from a pivot table in Excel 2003 NEvans009 Excel Discussion (Misc queries) 3 February 6th 07 11:13 PM
How to make a field created a part of the Pivot Table Field List? drhell Excel Discussion (Misc queries) 0 January 30th 07 12:13 AM
pivot table formulas for calculated field or calculated item Vicky Excel Discussion (Misc queries) 3 June 6th 06 05:06 AM


All times are GMT +1. The time now is 04:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"