Some Year But Unfortunately not This Year
Report Column
- Donor Name
- Email Address
- Year listing e.g. (last 3) it show 2006, 2007, 2008 in separate column with current Year
Filter
- Group
- Contribtuion Type
- Donor Name (contain)
Result
Donor Name |
Email |
2006 |
2007 |
2008 |
2009 |
|---|---|---|---|---|---|
Ms Sheila W Reynolds Sr |
sheila@demo.com |
$50 |
$150 |
$75 |
$0.00 |
Mr Bruce A Roberts Sr |
bruce@demo.com |
$100 |
$100 |
$100 |
$0.00 |
Mrs Melinda R Jones Jr |
melinda@demo.com |
$200 |
$170 |
$100 |
$0.00 |
Mrs Chetan O Jameson Sr |
chetan@demo.com |
$50 |
$50 |
$50 |
$0.00 |
Ms Bill G Jones Sr |
billjones@demo.com |
$100 |
$170 |
$100 |
$0.00 |
Total |
|
$500 |
$640 |
$425 |
$0.00 |
Labels

1 Comment
Hide/Show CommentsMay 27, 2009
JoeMurray
The totals by year of all contacts are less organizationally useful that a total for displayed prior years by contact, which could then be sorted to prioritize individuals to be contacted. Optionally iltering on this using min and max would be very nice.
I would suggest adding address fields and phone fields as optional columns, so that the results can be used for mailing and phoning as well as emailing.
Might be useful to have filtering on prior years' totals, so that one could get all those who gave more than $250 in 2007 but nothing in 2008. This would be particularly useful in early January where the current calendar year will mostly be zero for all donors in the database.