Before working in Crystal Reports, make sure that you have at least the following fields in your exported data:

  • Constituent Sort Key
  • Summary Information > Total Amount of Gifts (filtered for desired date range, gift types, etc)
1. Create a Group on the Summary field for Total Amount
2. User the Specified Order Grouping to create groups on the ranges of total amounts for the different categories
3. Click OK
4. Insert a second group based on the Constituent Sort Key