HELP WITH CALCULATED FIELDS

[mdeblois1]

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,

 

[dtaylor]

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]

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
	A	B	C	D	E	F	G	H	I
1	item	Qty	unitCost		SumofextCost
2	1	5	6		item	Qty	unitCost	Total
3	2	4	6		1	5	6	30
4	3	3	6		2	4	6	24
5	4	2	6		3	3	6	18
6					4	2	6	12
7					GrandTotal			336
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.