I'm needing a way to add 2 columns to contribution summary report, 1 for displaying "last contribution date" and 1 for "last contribution amount" in a CiviReport. Is there an easy way using the UI to do this? If not, is there a way to write a plain SQL query that shows up as a report?

1 Answer 1


The way we have approached this in the past is to install/enable the Summary Fields extension, and set that up so it calculates the Last Date and Last amount, which are then available as custom fields you can add to any report.

  • 2
    As @pete has mentioned, yes use summary fields. Referencing a CiviCRM TV session we did only a couple of weeks ago on the subject. youtu.be/vJ7QZxLgogQ Commented Dec 20, 2021 at 22:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.