Using column data to quantify Pivot table

[eschrichj]

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.

	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

 

[eschrichj]

Also, I should mention that there is currently a separate worksheet with incredibly long sumif statements that does give me the correct amount of occurrences, but I hoped there was a way to get the data I needed with only using the source data and Pivot Tables for easier analysis.

 

[GraH]

Perhaps set value to SUM like shown below?

 

[eschrichj]

That gets me much closer to what I was looking for thank you.
I think the only difference in the numbers now is incorrect data logging.
I cant believe I overlooked that, but thank you for the prompt response!

 

[GraH]

Pleased to read this... I hope you nail it and not just come close.