For best results in a PivotChart report, work in the associated PivotTable report where you can see the individual data values that the formula calculates.
When there are multiple formulas for a calculated item, the default formula entered when the item was created has the calculated item name in column B. For additional formulas for a calculated item, column B has both the calculated item name and the names of intersecting items.
For example, you might have a default formula for a calculated item named MyItem, and another formula for this item identified as MyItem January Sales. In the PivotTable report, you'd find this formula in the Sales cell for the MyItem row and January column.
Edit a calculated field formula
Edit a single formula for a calculated item
Edit individual formulas for specific cells of a calculated item
For example, if a calculated item named Strawberries has a formula of =Oranges * .25 across all months, you can change the formula to =Oranges *.5 for June, July, and August.
To change the formula for several cells, hold down CTRL and click the additional cells.
Note When you edit a formula in a PivotChart report or its associated PivotTable report, some chart formatting may be lost.