Hey Guys,
I have a data that currently looks something like this...
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]WO Nbr
[/TD]
[TD]Part Nbr
[/TD]
[TD]SCP[/TD]
[TD]Orig WO Qty
[/TD]
[TD]Qty Scrap
[/TD]
[/TR]
[TR]
[TD]10044
[/TD]
[TD]31593
[/TD]
[TD]PDB
[/TD]
[TD]408
[/TD]
[TD]22
[/TD]
[/TR]
[TR]
[TD]10044
[/TD]
[TD]31593
[/TD]
[TD]HMI
[/TD]
[TD]408
[/TD]
[TD]11
[/TD]
[/TR]
</tbody>[/TABLE]
Obviously there are a ton more row, scrap codes, etc. But how would I go about setting up a pivot table that gets me scrap %? Which would pretty much be the sum of qty scrap / orig wo qty (408). Everytime I try and add orig wo qty to values it counts it as 816 instead of the 408. Please help
I have a data that currently looks something like this...
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]WO Nbr
[/TD]
[TD]Part Nbr
[/TD]
[TD]SCP[/TD]
[TD]Orig WO Qty
[/TD]
[TD]Qty Scrap
[/TD]
[/TR]
[TR]
[TD]10044
[/TD]
[TD]31593
[/TD]
[TD]PDB
[/TD]
[TD]408
[/TD]
[TD]22
[/TD]
[/TR]
[TR]
[TD]10044
[/TD]
[TD]31593
[/TD]
[TD]HMI
[/TD]
[TD]408
[/TD]
[TD]11
[/TD]
[/TR]
</tbody>[/TABLE]
Obviously there are a ton more row, scrap codes, etc. But how would I go about setting up a pivot table that gets me scrap %? Which would pretty much be the sum of qty scrap / orig wo qty (408). Everytime I try and add orig wo qty to values it counts it as 816 instead of the 408. Please help
