- 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
- Create a pivot report. Use Card Type for the Columns, Gift Amount for the rows, and Gift Count in the Totals field.
- Create a gift query of the appropriate gifts, if applicable
- Create a gift export in Excel format using the query created in step 1.
- On the Output tab, select Amount and Credit Type into Excel format for the appropriate gifts
- Open the file in Excel, sort it by credit type, and sum up the columns for each credit type