| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
| Pivot Table Calculated Item | Excel Discussion (Misc queries) | |||
| Pivot Table Calculated Item | Excel Discussion (Misc queries) | |||
| Pivot Table Calculated Item | Excel Discussion (Misc queries) | |||
Linear Mode
