I'm looking for a way to look at the following categorized information:
the past 10 years or so of donors who give gifts between $2,500-4,999 (segment 1), 2,000 - 4,999 (segment 2), and $1,000 - $1,999 (segment 3). I would like to know the total giving of each FY, and the number of gifts that make up that amount.
I can't quite find a report or output criteria to give me the above. Does anyone have any pointers? Thanks!
I have an output set element of Contributions by Campaign (our campaigns go by fiscal year). I like to do this because some contributions are slated for different annual funds than the current fiscal year (particularly at the turn of the fiscal year).
Data Select: sum(cont_amt)
Data From: t_contribution
Data Where: campaign_no IN (<<p#>>) Where p# is the query parameter for campaign that you have set up.
Then I add that to a set and execute from there.
If you want to go purely by date for a true fiscal year capture, you could switch the Data Where to: cont_dt BETWEEn <<p1>> and <<p2>> (I'm assuming you have the default start and end date query parameters here).
-Kate PowellDevelopment Manager