Delete calculated field Excel 2013 Pivot Tables

Folks,
I have looked for a way to delete and or modify a custom calculated field in Excel 2013 Pivot Tables. Any suggestions?
Frank FreeseAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ejgil HedegaardCommented:
Select the field in the pivot table, right click, and use the remove option.

Or select the pivot table.
Go to formulas on the pivot settings tab.
Select the field in the name box at the top.
Then edit the formula, or use the delete button.
Frank FreeseAuthor Commented:
How do I remove it (customized formula) from the PivotTable Fields?
Ejgil HedegaardCommented:
Not sure I understand what the problem is.

Above description explains how to delete or modify the formula field.

If you just don't want to see it in the pivot table, remove it like any other field in the pivot table.
In the field set up box, select it, hold down the left mouse button, drag it outside the box and drop it.
Or remove the mark in the field selection box at the top of the field set up box.
If you don't see the field selection, use the Fieldlist button on the ribbon.
Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

Frank FreeseAuthor Commented:
thanks for hanging in here with me. in the image below what I am trying to do is remove from the Pivot Table Field the calculated field labeled Average Sales that I created. I've tried everything you suggested but I can't seem to get this removed from my PivotTable Field list.
average sales
Ejgil HedegaardCommented:
That is the field list where you can deselect it to be shown in the pivot table.

To delete the field.
Select a cell in the column "Average sales" In the pivot table on the sheet.
It does not matter if it is the header, values or the grand total.
Right click, and on the menu that comes up, use the delete (or remove) option.

The other method is to use the same as where the pivot formulas are created, and delete the formula field there.

In case it is not a formula field, but a remain from a previous pivot set up, and the field is no longer in the data.
Right click any cell in the pivot table on the sheet.
Select Settings, and then select the Data tab.
In the selection box at the bottom for posts to keep, change to None.
Then refresh the pivot table if it does not automatically do it.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Frank FreeseAuthor Commented:
thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.