How to remove calculated field from pivot table?
If you have add some new calculated fields into your pivot table as How to add calculated field to pivot table article is mentioned. And after viewing the data analysis of the new custom calculation in your pivot table, you want to remove the calculated field to restore the pivot table. Today, I will talk about how to delete the calculated field temporarily or permanently from pivot table.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
If you want to remove the calculated field temporarily, and later, you can apply it again, you just need to hide the field in the Field List.
1. Click any cell in the pivot table to display the PivotTable Field List pane.
2. In the PivotTable Field List pane, please uncheck the calculated field that you are created, see screenshot:
3. After removing the check mark of the custom calculated field, this field will be removed from the pivot table.
Note: If you need the calculated field appear, just check the field again in the PivotTable Field List pane.
To permanently remove a calculated field, do with following steps:
1. Click any cell in your pivot table to display the PivotTable Tools tabs.
2. Then click Options > Fields, Items, & Sets > Calculated Field, see screenshot:
3. In the Insert Calculated Field dialog box, please choose the name of your custom calculated field from the Name drop down list, see screenshot:
4. Then click Delete button and click OK to close this dialog, and now, your calculated field has been removed permanently, you will not restore it any more.
Recommended Productivity Tools
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 1 months agomil gracias
To post as a guest, your comment is unpublished.· 3 years agoHi, I'm a pivot table beginner - I just started this morning. I only know the most basic steps. I have a problem though, my pivot table has a row label that says "(blank)", and the corresponding value is also empty. I tried deleting it but I get an error message "Cannot change this part of a PivotTable report." I'm using Excel 07. Can anyone help me please? Thanks :)