Answers.Body: <p>The way we have approached this in the past is to install/enable the <a href="https://civicrm.org/extensions/summary-fields" rel="nofollow noreferrer">Summary Fields extension</a>, 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.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-12-20T22:17:23.913Z
Answers.Text: As @pete has mentioned, yes use summary fields. Referencing a CiviCRM TV session we did only a couple of weeks ago on the subject. https://youtu.be/vJ7QZxLgogQ
Answers.UserDisplayName: Parvez Saleh
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-12-20T20:53:00.433Z
Answers.LastActivityDate: 2021-12-21T02:42:47.773Z
Answers.LastEditDate: 2021-12-21T02:42:47.773Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>I'm needing a way to add 2 columns to contribution summary report, 1 for displaying &quot;last contribution date&quot; and 1 for &quot;last contribution amount&quot; 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?</p>
  
Tags: <custom-fields><civireport><reports><custom-reports><sql>
Title: How to get "Last contribution amount" and "Last contribution date" into report?
ThreadText: # How to get "Last contribution amount" and "Last contribution date" into report?
  
  (Asked by: username_0 on 2021-12-20)
  
  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?
  
  **Tags:** custom-fields, civireport, reports, custom-reports, sql
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2021-12-20. Score: 6 | Accepted answer
  
  The way we have approached this in the past is to install/enable the [Summary Fields extension](https://civicrm.org/extensions/summary-fields), 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.
  
  > **Comments:**
  > **username_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. https://youtu.be/vJ7QZxLgogQ  
  
  ---
  
  