PivotTable toolbar, Formulas, Calculated Item

J

Jacob

To my excel-2003 pivot table report I am unable to add a - Calculated Field -
as the menu item "Calculated Item" is not found on "Pivot Table Tool Bar",
"Formulas". I found the "Excel Tips and Techniques" is also do not have any
reference to this subject.
 
D

Debra Dalgleish

Is Calculated Item not on the menu at all, or is it dimmed out, and not
available to use?

If it's visible, but dimmed out, try selecting a heading cell in the
pivot table's column or row area. Then choose
PivotTable>Formulas>Calculated Item.
 
Top