| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not including blank fields in pivot tables | Excel Worksheet Functions | |||
| Sum of Calculated fields in Pivot Table | Excel Discussion (Misc queries) | |||
| pivot tables - calculated fields | Excel Worksheet Functions | |||
| Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
| Pivot Tables, calculated fields | Excel Discussion (Misc queries) | |||
Linear Mode
