Hey Guys,
I have a data that currently looks something like this...
<tbody>
</tbody>
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...
WO Nbr | Part Nbr | SCP | Orig WO Qty | Qty Scrap |
10044 | 31593 | PDB | 408 | 22 |
10044 | 31593 | HMI | 408 | 11 |
<tbody>
</tbody>
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