PIVOT TABLE HOW TO INSERT.......

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

Guest

Hi i have EXCEL 2003, i just created a pivot table of my data, but i would
like to create a calculated field to my pivot table. I watched a tutorial
for that and on that version of EXCEL u just right click on the pivot table
and select formula. On this version of 2003 i dont have that option. Pls help
me out thank you,,,,....

Alex
 
Hi Alex

On the PT Toolbar, there is a dropdown. Select that and you will see the
Calculated Field option.
 
Hi Alex,

1. From the Pivot Table Toolbar click on the Pivot Table drop-down menu ,
2. Click on Formula
3. Click on Calculated Field.

If you do not see the Pivot Table Toolbar, select any cell on your pivot
table, right click and select Show Pivot Table Toolbar and follow the steps
above.

Hope this helps.
 

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 inserting calculated pivot fields into Pivot Table (2007) 1
Pivot Table criteria 2
Pivot table wizards 2
Insert Calculated Field in a Pivot Table 1
Pivot Tables 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot table filter list - listing irrelevant subcategorys 1
about pivot table 1

Back
Top