A Pivot Report can be created to total the number of times a letter code appears on gifts:
  1. Start a new Gift query.
  2. On the query's Criteria tab, add any desired criteria, such as gift date, gift type, etc.
  3. On the query's Output tab, add the field Gift Information > Letter Code. Add any additional fields desired for the Pivot Report.
  4. Go to File > Save to name and save the Query.
  5. Close the Query.
  6. Click on Reports in the left menu.
  7. Click on Pivot Reports.
  8. Click on New at the top.
  9. In the New Pivot Report, click on the binoculars to search for the query created in steps 1 through 5. (Mark Refresh Pivot data each run if this report will be run regularly.)
  10. Click Generate.
  11. Complete the report following the steps for your Raiser's Edge version:
In The Raiser's Edge 7.94 and higher:
  • In Excel, find the PivotTable Field List.
  • Mark Gift Letter Code.
  • Click and drag Gift Letter Code to the lower right Values box.
  • The report will generate on the left.

In The Raiser's Edge 7.93 and earlier:
  • In the New Pivot Report window, click on Field List button (next to last button).
  • Click, drag, and drop Gift Count to the Drop Totals or Details Fields Here area.
  • Click, drag, and drop Gift Letter Code to the Drop Row Fields Here area.
  • The report will generate.