How to Edit a Calculated Field PivotTable
You can edit calculated fields from your PivotTable by utilizing the tools on the PivotTable Tools tab. PivotTables let you quickly analyze your data in your spreadsheet. PivotTables let you summarize, filter and sort large volumes of data according to your needs. Once the PivotTable is created, you can further define it by adding calculated fields to further analyze and dissect your data.
Other People Are Reading
Instructions
-
-
1
Open Excel 2010 and open a workbook containing a PivotTable.
-
2
Click the worksheet containing the PivotTable. Click the PivotTable. The PivotTable Tools Tab appears. Click the "Options" tab and "Fields, Items, and Sets." Select "Calculated Field." Your calculated fields are displayed.
-
-
3
Select the calculated field formula that you want to edit. Click the "Formula" box and select "Modify." Edit the formula and click "OK." Your calculated field is edited in your PivotTable.
-
1
