How to Edit a Calculated Field PivotTable

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.