View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Insert Calculated Field in a Pivot Table

Hi Connie

On the Pivot Table toolbar, select the dropdown labelled Pivot Table and you
will see Formulas.

--
Regards
Roger Govier

"Connie Martin" wrote in message
...
I have some old instructions (nice pictures and all) of how to insert a
new
formula field in a pivot table from Excel 2000 which is not the same in
Excel
2003, which I am now using, and I can't find out how to do it, and Help is
no
help. In Excel 2000 you right-clicked on a column header in the Pivot
Table
and selected "Formulas" and then "Calculated Field...". But that option
is
not in the menu in Excel 2003. Where did it go? Connie