# HELP WITH CALCULATED FIELDS

#### mdeblois1

##### New Member
Hi everyone,

Please help with calculated fields. I have a pivot table in which I have selected calculated fields. The insert calculated field dialog pops up. However, when I type a name and a formula, I get the following message:

"An item cannot be found. Check that you've typed the name correctly and the item is present in the Pivot Table report."

Of course the item isn't present--I am trying to add the field!

Thank you,

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### dtaylor

##### Active Member
hi there and welcome to the board!

you will need to add the field that is part of your formula to the pivot table. redo your pivot and bring in the missing field - once you do this you should have no problem inserting a calculated field.

Dan

#### Yogi Anand

##### MrExcel MVP
Hi mdeblois1:

Welcome to MrExcel Board!

The calculate field has to be built using fields from within the Pivot Table -- following is a simple example ...
y040107h1.xls
ABCDEFGHI
1itemQtyunitCostSumofextCost
2156itemQtyunitCostTotal
324615630
433624624
542633618
642612
7GrandTotal336
8
Sheet3

The source data has fields for Item, Qty, and unitCost. In the PivotTable, I have used a calulated field

extCost = Qty*unitCost

Please note that my calculated field extCost is only using fields that already exist in the PivotTable. I hope this helps.

Replies
3
Views
238
Replies
1
Views
153
Replies
0
Views
767
Replies
1
Views
719
Replies
8
Views
1K

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,152,322
Messages
5,769,451
Members
425,548
Latest member
macjagger17

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back