I am trying to make a report that shows Contacts with at least 1 Opportunity. I have accomplished this, however, I only want to see the contact listed once but also not grouped (like in photo)enter image description here.

Ideally, I'd like to just see the Contact Name and that date field just once and not for every opportunity.

Edit: The date field is related to the Contact and has nothing to do with the Opportunity record

  • What Date field are you showing? If the Opportunity Close Date, and a Contact has more than one Opportunity, which record's Date do you want to show?
    – David Reed
    Jan 16, 2020 at 17:55
  • updated the question
    – MMeadows
    Jan 16, 2020 at 18:05

1 Answer 1


You should apply a Cross Filter for "Contacts with Opportunities". Do this in a Contacts report rather than a Contacts and Opportunities report.

This will allow you to report at the Contact level, applying a filter based on Opportunities without including Opportunity data in the report body.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .