CiviCRM Community Forums (archive)

These searches are not possible in 1.9 and prior w/o doing some fancy footwork in a spreadsheet (comparing exports of folks who contributed in x year to those who contributed this year ....). OR you could create a BIRT report which does those queries.

The good news is that we've added a custom search framework which will make it much easier for folks with a bit of tech skills to create searches which do the above... AND one of the sample custom searches we plan on shipping with the release handles the oft-needed LYBNTY (last year but not this year) search. I hope to be making that sample available on the 2.0 sandbox in the next week or so and will blog / announce it when it's up there.

It appears that this query will at least find the people-  Works perfectly in Access:

SELECT civicrm_contact.display_name, Sum(civicrm_contribution.total_amount) AS SumOftotal_amount
FROM civicrm_contact INNER JOIN civicrm_contribution ON civicrm_contact.id = civicrm_contribution.contact_id
GROUP BY civicrm_contact.display_name;

Also works in PHPMyAdmin.

Sorting can be added easily, or done in Access or Excel or PHPMA.

Have fun!
Ken