When querying on Summary Information, Total Amount, include only pledges or only pledge payments toward the total instead of including both pledges and pledge payments. For example:

To query on constituents who gave at least $1,000 in pledges, select:

Summary Information*, Summary for Gift, Total Amount. On the Filters tab, select:
Gift Information, Gift Type one of Pledge, MG Pledge

To query on constituents who gave at least $1,000 in regular cash gifts and pledge payments, select:

Summary Information*, Summary for Gift, Total Amount. On the Filters tab, select:
Gift Information, Gift Type one of Cash, Pay Cash, MG Pay Cash (If appropriate select all other Pay gift types.)

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

To combine the results of the above queries, merge the queries using the OR operator.