I'm trying to find a way to reference data from 2 tables in one Pivot Table and not having much luck.
I have one table with scrap detail (SCRAP) and another table that has a summary of the production (PROD). I'd like to be able to show scrap as a percentage of production for a certain scrap reason and part number. See the tables below.
https://www.dropbox.com/s/kw9ycllwow3fz4m/Chandoo.xlsm?dl=0
I have one table with scrap detail (SCRAP) and another table that has a summary of the production (PROD). I'd like to be able to show scrap as a percentage of production for a certain scrap reason and part number. See the tables below.
https://www.dropbox.com/s/kw9ycllwow3fz4m/Chandoo.xlsm?dl=0