P
PFL
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
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