Finding records which have only given to 1 Gift Subtype

Dan Beacon
Dan Beacon
Fourth Anniversary Participant Facilitator 1 Blackbaud Certified
in Blackbaud Altru® General Discussions

Evening,

I'm looking to exclude people who have ONLY made gifts (could be more than 1) to one gift subtype.

I need to include people who have given to this subtype AND another subtype.

I'm struggling with how to do this! Does anyone have any thoughts on how to do this please?

Many thanks

Tagged:

Comments

  • Ruth Droescher
    Ruth Droescher
    Third Anniversary Kudos 1 Name Dropper Participant

    @Dan Beacon Can you clarify what you mean by gift subtype? Is this a revenue category you're applying, or do you mean the actual revenue application like pledge, recurring gift, donation, etc?

    If you bring the field in to the query results and do a count of that field, for example revenue application, it should give the total number of unique application types by constituent. You could then use the sort and group options to limit to only constituents where the count field is > or < the number you're looking for.

Categories