ExcelBanter - Pivot Table - Calculated Item

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table - Calculated Item (https://www.excelbanter.com/excel-discussion-misc-queries/198980-pivot-table-calculated-item.html)

Nigel

Pivot Table - Calculated Item

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

Debra Dalgleish

Pivot Table - Calculated Item

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

Nigel wrote:
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

--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Nigel

Pivot Table - Calculated Item

Apologies for the delay in thanking you as I've been away from my PC.

Nigel

"Debra Dalgleish" wrote:

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

Nigel wrote:
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

--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

All times are GMT +1. The time now is 08:32 AM.