1. Create a gift query filtering on the desired criteria.
  2. On the Output tab, select the following fields:
Gift Information> Gift Amount
Appeals> Appeal Category
  1. Run the query and save it.
  2. Go to Reports, Pivot reports and create a new Pivot report.
  3. Include the gift query created in Steps 1-3. Click Generate.
  4. From the Pivot Tables Field list, drag the Appeal Category field to the Row section.
  5. Then drag the Total Gift Amount field to the Totals section.
This will show the total given for each appeal category based on the criteria in the gift query.