melissa hodges - You can assign a unique no to each row based on your criteria using a cumulative_sum function as below
for example: Rank = cumulative_sum (1, product no , inspection id, inspection type )
this will create unique numbers for each of the row by product no , inspection id, inspection type. You can use the filter Rank < 10, this will restrict the records.
Hope this helps.