1. Create a gift query of the appropriate gifts. Consider filtering on Gift Information, Card Type not blank. On the Output tab, select Gift Information, Gift Amount and Gift Information, Card Type
  2. Create a pivot report. Use Card Type for the Columns, Gift Amount for the rows, and Gift Count in the Totals field.

OR

  1. Create a gift query of the appropriate gifts, if applicable
  2. Create a gift export in Excel format using the query created in step 1.
  3. On the Output tab, select Amount and Credit Type into Excel format for the appropriate gifts
  4. Open the file in Excel, sort it by credit type, and sum up the columns for each credit type