Pivot Table - Calculated Item

N

Nigel

I have greated a calculated item to sum the first three months of the year as
Qtr1. Is there a way to edit this formula.

Thanks

Nigel
 
D

Debra Dalgleish

Yes, you can select one of the item headings, then on the PivotTable
toolbar, click PivotTable>Formulas>Calculated Item
From the Name dropdown list, select the item that you want to edit
Change the formula, then click Modify, and click OK.
 
Top