Hi folks,
I have a spreadsheet which contains quality data for our production. It includes the week, serial number of the item and quality defect. I have duplicate serial numbers on the sheet as an item can have multiple defects. I have a pivot table which totals the defects which occured...