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

Top