Insert Calculated Field in a Pivot Table

C

Connie Martin

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
 
R

Roger Govier

Hi Connie

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

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

Doughnut Chart linked with the slicer in the pivot table 0
Slicers and Calculated Items in Pivot Table 2
Dealing with a Pivot Table (when I don't want to) 0
Dates In Excel 5
Power Pivot. Yikes. 0
Additional columns for Pivot table 0
Insert multiple objects at once ? 3
Problem inserting calculated pivot fields into Pivot Table (2007) 1

Top