Creating a calculated field in a Pivot Table

P

Philip J Smith

Hi I saw this response from rsantaro dates 19 Nov 2007.

Create a calculated field.

In Excel 2007: click in a cell in you PivotTable, under PivotTable Tools |
Options | Formulas select Calclulated Field...

Input a Name for the Calculated Field in the Name text box (the name will
show up as a field in the Field List).

However I can't find "Pivot Table Tools" on any menu or ribbon - I'm missing
something, can anyone point me in the right direction please?
 
K

Karen

I'm not sure if you mean "Pivot table toolbar". If it is, you can find it here:

Select any cell in the pivot table, do a right click and select the second
last item on the list - "Show Pivot Table Toolbar". Click that and you will
be able to see the toolbar.
 

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
Delete calculated field 1
Calculates field in pivot table 2
Pivot Table calculated item 4
Insert Calculated Field in a Pivot Table 1
Pivot Table - Calculated Field 2
Pivot Table - Calculated Field - Percentage - Rept 2
Pivot Table Calculated Field - Sum/count 1

Top