Answers.Body: <p>I recommend the summary fields extension:
  <a href="https://civicrm.org/extensions/summary-fields" rel="nofollow noreferrer">https://civicrm.org/extensions/summary-fields</a></p>
  <p>It'll keep a calculated copy of the last contribution amount (and many other useful fields) as custom fields of the contact, making reporting like this much easier.</p>
  <p>Because contributions are stored in a separate table, generating fields like 'last contribution' tends to be complicated and mixing it with other values isn't going to be well supported in most reports, but pulling in custom contact field values is almost always supported.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-12T17:13:56.087Z
Answers.Text: Thank you, this sounds just right, i will try it
Answers.UserDisplayName: Becca Thomson
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-05T17:05:14.927Z
Answers.LastActivityDate: 2021-02-05T17:05:14.927Z
Answers.UserDisplayName: Alan Dixon
Body: <p>When running a payment report using the Contribution summary,  along with the columns showing number of payments, payment aggregate and payment average, I would like to be able to see the date and amount of the last/most recent payment. This information can be separately gathered by running a Contribution detail report, but it is a lengthy process going through two separate spreadsheets when, ideally, I would want this information regularly, so having the data within the Contribution summary report who be ideal.</p>
  
Tags: <civireport>
Title: How do I add a column to a Contribution Summary report which will show the date and amount of the most recent payment/donation?
ThreadText: # How do I add a column to a Contribution Summary report which will show the date and amount of the most recent payment/donation?
  
  (Asked by: username_0 on 2021-02-05)
  
  When running a payment report using the Contribution summary, along with the columns showing number of payments, payment aggregate and payment average, I would like to be able to see the date and amount of the last/most recent payment. This information can be separately gathered by running a Contribution detail report, but it is a lengthy process going through two separate spreadsheets when, ideally, I would want this information regularly, so having the data within the Contribution summary report who be ideal.
  
  **Tags:** civireport
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2021-02-05. Score: 2
  
  I recommend the summary fields extension:
  <https://civicrm.org/extensions/summary-fields>
  
  It'll keep a calculated copy of the last contribution amount (and many other useful fields) as custom fields of the contact, making reporting like this much easier.
  
  Because contributions are stored in a separate table, generating fields like 'last contribution' tends to be complicated and mixing it with other values isn't going to be well supported in most reports, but pulling in custom contact field values is almost always supported.
  
  > **Comments:**
  > **username_0**: Thank you, this sounds just right, i will try it  
  
  ---
  
  