Is there any way to filter a table or pivot table to only show the values displayed in a certain column? I have a column, "All" with all of the part numbers, with the quantities next to it, and "Defective" with only defective part numbers, and the quantities next to it. Each pair of columns is in a different workbook, so I am bringing them into one workbook to find the percentage of defective parts for each part number, so I want to get rid of all part numbers in "All" that do not appear in "Defective".