Pivot tables - calculated fields
 

I have two pivot tables :-
PT No 1 has "Bills of Material codes" and the "qtys of raw materials" to
make 1 of each finished product.
PT No 2 has the same "Bills of Material codes" but the "number of finished
items" of each to be manufactured.
I need a calculated field in PT 1 to look at PT 2, look for the
corresponding "Bill of Material Code" and take the "No of Finished items" and
multiply it by the PT1-"Qty of Raw Materials" = total raw materials required.

New at this so would appreciate and help - Many thanks