Report needed to show top 25 individual gifts over past 5 years

Cathy Spencer

I need help in creating a report that shows the top 25 individual (not cum) gifts over the past 5 years. I am not seeing anything in Analytical reports that meets that need, and can't figure out how to build a query that will do it.  Any suggestions?  Thank you in advance!

Anne Delaney

Cathy Spencer:

I need help in creating a report that shows the top 25 individual (not cum) gifts over the past 5 years. I am not seeing anything in Analytical reports that meets that need, and can't figure out how to build a query that will do it.  Any suggestions?  Thank you in advance!

You'll find in Reports if you go into Donor Category Reports. From there you can select the dates and the amount that you are looking for. Hope this helps.

 

Cathy Spencer

Thank you Anne

Barbara Schlichter

Cathy Spencer:

I need help in creating a report that shows the top 25 individual (not cum) gifts over the past 5 years. I am not seeing anything in Analytical reports that meets that need, and can't figure out how to build a query that will do it.  Any suggestions?  Thank you in advance!

You may want to try Demographic and Statistal à Comparisons and Summaries.  You can pick up to 5 years on the report periods.

JoAnn Strommen

If you find that the reports combine gifts and report out cumulative giving you may have to resort to query.  I'd try a constitiuent query, gift amount greater than $XXX, set any criteria for date, gift type cash or pledge, funds, etc.  Take a guess at what would pull only top gifts.  Could be done with gift query also.  If it pulls too many, up the criteria amount.  Just ran quick test and works for a quick list.