| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
PivotTable toolbar, Formulas, Calculated Item
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. |
|
#2
|
|||
|
|||
|
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 PivotTableFormulasCalculated Item. Jacob wrote: 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Calculated Item | Excel Discussion (Misc queries) | |||
| Problem with named formula's | Excel Worksheet Functions | |||
| PivotTable toolbar missing? | Setting up and Configuration of Excel | |||
| Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
| Excel 2002 -> Problem with calculated fields in Pivottable | Excel Discussion (Misc queries) | |||
Linear Mode
