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.
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
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.
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 years agomil gracias
- To post as a guest, your comment is unpublished.· 4 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 :)