HELP WITH CALCULATED FIELDS

mdeblois1

New Member
Joined
Jan 7, 2004
Messages
1
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!

Yuck--please help.

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
Joined
Mar 21, 2002
Messages
379
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
Joined
Mar 12, 2002
Messages
11,454
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.
 
Master Excel Bundle

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.

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top