This is my first post, so let me know if I am asking right.

I have a large Access Database which tracks my company's quality management, particularly in regards to quality quarantining. For a bi-yearly meeting, I need to make a chart that shows the top five specs for # of production pallets quarantined, and for each one, the top five reasons for quarantine. I've made the query for this data and transferred it to the pivot chart. However, when I look up the top five for both spec and defect it only shows the defects that fall within the overall top five, not per spec.



Essentially, if I have specs 1, 2 and 3 and I want the top 3 defects, spec 1's main defects may be A, B and C while spec 2 may be D, E and F and spec 3 may be C, D and F. Is there a way to specify that you want the top 3 per spec and not overall?

Thank you