I'm looking to create a report of Opportunities with some native Opportunity filters. These Opportunities also have a custom Lookup field pointing to a Contact: Project Contact
.
In the Opportunities with Contacts report, I want to further filter by a custom field (a checkbox) in the Contact Object.
In the report I can access related Contacts for the Opportunities, but I can't access the fields of the specific Contact in the Project Contact
field.
Apologies if it's covered elsewhere - I have had a look at docs and elsewhere on SE, but none of it is ringing any bells thus far.
Any ideas?