I have a Contact Object and a custom object called "License". On the License object custom field "Type" specifics if it is an "Evaluation" or "Commercial". Additionally, custom field "Product" specifics the name of the Product this license is for.
Licenses are connected to Contacts via Lookup field on the License. A Contact can have many License but a License can only have one Contact.
I am trying to build a report that shows Contacts that have a License of Type Evaluation and another License of Type Commercial for the same Product.
Can anyone provide suggestions on how to build a report that could solve this? I have been working with a joined report but cannot figure out how to show Contacts that only have BOTH of these licenses.