"Nested" or Dependent Top Nth

[ivanolo]

Please forgive me if this has been asked before, but my search came up empty.

I'm working on a report to track product issues. I'd like to have a "Top 3 Issues" category and right next to it a "Top 3 Products" category that shows which products are most affected by the issue selected, like this:

Example.png

Two drop-down menus (location and division) will drive both Top 3 categories.

Test_Data.xlsx

The data is dynamic, so I would like to have the calculations performed automatically. Duplicates must be accounted for, and I do not want to use pivot tables (the one included in the data is for reference purposes).

I know how to use IF, INDEX, MATCH, COUNTIFS, MAX, and LARGE. I haven't figured out a way to combine them to accomplish this task, however.

Your help is greatly appreciated!