PivotTable toolbar, Formulas, Calculated Item

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Calculated item in Pivot Table 1
Pivot table, IF function, calculated item versus calculated field 1
Pivot Table calculated item 4
Creating a calculated field in a Pivot Table 1
Insert Calculated Field in a Pivot Table 1
The PivotTable field name is not valid (error) 1
Pivot Table criteria 2
Calculated Item causes undue repitition in pivot table 2

Back
Top