Hello,
I am looking to create a pivot table to track the scrap created by a manufacturing company.
Currently the source data is similar to the table below.
When I create a pivot table to track the occurrences of "cause" it is only counting the times each cause appears in the table.
Is there a way to quantify "cause" (or any other column), by the value in the "Qty Scrap" column of the same row?
Thanks for your help.
I am looking to create a pivot table to track the scrap created by a manufacturing company.
Currently the source data is similar to the table below.
When I create a pivot table to track the occurrences of "cause" it is only counting the times each cause appears in the table.
Is there a way to quantify "cause" (or any other column), by the value in the "Qty Scrap" column of the same row?
Thanks for your help.
Customer | Part Number | Job Number | Feature | Defect | Cause | Resource | Qty Scrap | Inspector | |
---|---|---|---|---|---|---|---|---|---|
5/5/2020 | A | 123 | xyz | hole | mislocated | operator error | cnc punch | 47 | bill |
5/5/2020 | B | 456 | xya | hole | mislocated | offset | mill | 4 | bob |
5/5/2020 | A | 123 | xyb | gage | oversized | offset | cnc | 1 | bill |