• On the Criteria tab, select Summary information*, Summary for Gift, Total Gift Amount, Greater than or equal to 1. On the filters tab, select:


      Campaign ID equals [campaign]

      AND Gift Type one of [selected gift types]

      AND Gift date equals this fiscal year
       


      AND Summary information*, Summary for Gift, Total gift amount equals 0. On the filters tab, select:


      Campaign one of [all but the campaign that you chose before]

      AND Gift type one of [selected gift types]

      AND Gift Date equals this fiscal year.

     

    * For more information on selecting and filtering Summary Information fields in query, refer to BB237530.