As you can see the good pcs sum up because good and bad pcs are keyed in at each operation.
Would like to have the subtotal for good pcs to be the first operation good pcs - sum of bad pcs by operation.
How can this be accomplished in a pivot table.
Would like to have the subtotal for good pcs to be the first operation good pcs - sum of bad pcs by operation.
How can this be accomplished in a pivot table.