dropdown data creating merged categories

dropdown data creating merged categories

I'm creating an app to inventory my marketing content. A piece of content can only be one KIND (e.g. datasheet, brochure, white paper), but it can have many audiences (e.g. CIOs, CEOs, CFOs).

The form that I've created uses dropdowns to select the audience, and the user can select more than one. However, in the reports, the system is creating merged categories, instead of listing the assets twice in each category.

Here's what I'd like to see:

AUDIENCE = CFO
Assets A, B, D

AUDIENCE = CEO
Assets A, C

Here's what I'm seeing instead:

AUDIENCE = CFO
Assets B, D

AUDIENCE = CEO
Asset C

AUDIENCE = CEO, CFO
Asset A

How do I output reports in which the audience category is not merged? Specifically, I'd love a pivot table that shows me the count of the CFO assets (which is 3) and of CEO assets (which is 2), because Asset A works for both audiences.