The Raiser's Edge is unable to perform a summary of a summary field, we will have a measure of manual work to do to isolate the desired data from the results of the above queries.

  1. Create a new constituent query filtering on Total Amount of Gifts (within specific parameters) that is greater than or equal to $1000 AND Total number of gifts (within the parameters) is between 1 and 10.
     
  2. Create a new constituent query filtering on Total Amount of Gifts (within specific parameters) is greater than $1000. Output Total number of gifts (with or without the parameters) and make a manual selection from the exported results.