1. Create a Consecutive Years Report.
  2. On the General tab, mark Create output query.
  3. On the Format tab, highlight detail and enter the minimum number of consecutive years.
  4. Select all other parameters.
  5. Preview the report and save the output query.
  6. Open the output query.
  7. On the Output tab, select:
    • Gifts, Gift Date
    • Summary Information, Summary for Gifts, Consecutive Years Given.
    • The Edit Field Criteria screen appears. Click OK.
  8. Save and name the query.
    Note:These changes will be saved as a new constituent, dynamic query.
  9. Create a pivot report.
  10. Select the Field list Icon: Field List
  11. Expand the GftConsecutiveYearsGi~ field in the field list by clicking on the plus sign.
  12. Drag the GftConsecutiveYearsGi~ field to "Drop Row Fields Here".
  13. Expand the Gift Date Breakdown field in the field list by clicking on the plus sign.
  14. Drag the Year field to "Drop Columns Fields Here".
  15. Drag the Constituent Count field to "Drop Totals or Detail Fields Here".
  16. Click within the constituent count rows.
  17. Select the Show As button with the percent sign image button and select Percent of Grand Total.

    image of the completed pivot report

    The overall percentage will be represented by the Grand Total row. This includes all constituents (regardless of the consecutive years given) that was retained. The number of years in relation to the year will depend on the date selected on the General tab of the consecutive years report. In the example above the date range used is last calendar year with 3 as the minimum number of consecutive years. In the report above .44% of donors gave consecutively for 4 years. This includes the years of 1997, 1998, 1999 and 2000.

    For more information on creating and customizing pivot reports, refer to the The Raiser's Edge & Microsoft Office Integration Guide (PDF).