I want to make a report with Opportunity information. I want to filter out Opportunities where the Contact has an activity assigned to a specific User. Our activities are only linked to the contact, not to the Opportunity.

I couldn't figure out how to make a report type that links all three so I used two reports Contacts-Opportunities and Contacts-Activities and created a joined report. From there I could filter out contacts with the specific activities on one block, but that didn't eliminate the contact on the other side with the opportunity. Is this do-able? Am I over complicating it?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.