6 Replies Latest reply on Feb 13, 2019 1:37 AM by Paul Bussen

    How to show all contacts but only active memberships

    Paul Bussen

      Hello all,

       

      I need some help creating a report. I'm connected to salesforce and I have a reasonably simple data model, a contact and membership. Some contacts have active memberships, some contacts have inactive/expired memberships and some contacts have never had memberships. My data source is a left join between contacts and memberships with no filters.

       

      I'm trying to create a report the shows all contacts, but only active memberships. whenever I add a filter to only show active memberships or null I lose all the contacts that have expired memberships.  How can I create the report?

       

      Thanks in advance,

      Paul