Dynamic pivot sum
 

HI All:
Hoping that someone can help.

I created a pivot table for products(Page Field) that consist of
several different raw materials and their associated cost. For
exampleProduct A consist of 5 raw materials while Product B consist
of 7 raw materials while Product C consist of 8 raw materials but no
product consist of more thn 8 raw materials. I want to add the total
raw material cost Product A, B or C...Z) to Packing materials cost
(fixed) which is not part of the pivot table and is in a fixed row
below the pivot table. What dynamic sum formula can be used to Add
total raw materials for a particular product to packing material cost

You could use a GETPIVOTDATA formula to return the total from the pivot
table, and add that to the fixed cost. For example:
=GETPIVOTDATA("Total",$A$4)+B19

The functions arguments vary with the different Excel versions. There's
information in Excel's Help, and he

http://www.contextures.com/xlPivot06.html

PFL wrote:
HI All:
Hoping that someone can help.

I created a pivot table for products(Page Field) that consist of
several different raw materials and their associated cost. For
exampleProduct A consist of 5 raw materials while Product B consist
of 7 raw materials while Product C consist of 8 raw materials but no
product consist of more thn 8 raw materials. I want to add the total
raw material cost Product A, B or C...Z) to Packing materials cost
(fixed) which is not part of the pivot table and is in a fixed row
below the pivot table. What dynamic sum formula can be used to Add
total raw materials for a particular product to packing material cost



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

It worked perfectly

Thanks very much for your help.