Answers.Body: <p>I am going to try petednz's approach using Views Calc, but I hacked together a quick MySQL query that pulled me most of what I wanted</p>
  
  <pre><code>select year(receive_date) as year,(select display_name from civicrm_contact where civicrm_contribution.contact_id = civicrm_contact.id) as Name, contact_id, SUM(total_amount) as Gifts
  from civicrm_contribution 
  where (receive_date &gt;= '2015-11-01' and receive_date &lt;='2016-11-01') or (receive_date &gt;= '2016-11-02' and receive_date &gt;= '2017-11-01') or (receive_date &gt;= '2017-11-01' and receive_date &gt;= '2018-11-02')
  group by contact_id, year, financial_type_id
  having financial_type_id in (11, 12, 15, 25, 26)
  ORDER BY name
  </code></pre>
  
  <p>Perhaps it can help someone else</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-03T02:13:25.867Z
Answers.LastActivityDate: 2018-11-03T02:13:25.867Z
Answers.UserDisplayName: Zachary
Answers.Body: <p>I don't think there is such a report. I would probably look at using <a href="https://civicrm.org/extensions/summary-fields" rel="nofollow noreferrer">Summary Fields extension</a> and then adding a new calculated field that does your calculation - and then report on that.</p>
  
  <p>In drupal I would also consider doing this in Views and using eg views_calc to do the calculation for me instead of creating a calculated field</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-02T21:35:34.147Z
Answers.Text: I will need to compare 16-17, and 17-18 (etc.) going into the future. It seems like a view offers more flexibility. The other reporting requirement is to ask if they gave the same for X and Y year, but then increased or decreased in Z year.
Answers.UserDisplayName: Zachary
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-02T21:17:49.843Z
Answers.LastActivityDate: 2018-11-02T21:17:49.843Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>Is there a report in the Current version of CiviCRM that can tell us this? <a href="https://civicrm.org/extensions/advanced-fundraising-reports" rel="nofollow noreferrer">https://civicrm.org/extensions/advanced-fundraising-reports</a> seems to have reports that will show if the giving is increased or decreased year to year, but not if it's exactly the same. Thanks!</p>
  
Tags: <civireport>
Title: Donors who gave the same amount in X and Y year
ThreadText: # Donors who gave the same amount in X and Y year
  
  (Asked by: username_0 on 2018-11-02)
  
  Is there a report in the Current version of CiviCRM that can tell us this? <https://civicrm.org/extensions/advanced-fundraising-reports> seems to have reports that will show if the giving is increased or decreased year to year, but not if it's exactly the same. Thanks!
  
  **Tags:** civireport
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2018-11-03. Score: 1
  
  I am going to try username_1's approach using Views Calc, but I hacked together a quick MySQL query that pulled me most of what I wanted
  
  ```
  select year(receive_date) as year,(select display_name from civicrm_contact where civicrm_contribution.contact_id = civicrm_contact.id) as Name, contact_id, SUM(total_amount) as Gifts
  from civicrm_contribution 
  where (receive_date >= '2015-11-01' and receive_date <='2016-11-01') or (receive_date >= '2016-11-02' and receive_date >= '2017-11-01') or (receive_date >= '2017-11-01' and receive_date >= '2018-11-02')
  group by contact_id, year, financial_type_id
  having financial_type_id in (11, 12, 15, 25, 26)
  ORDER BY name
  
  ```
  
  Perhaps it can help someone else
  
  
  ---
  
  ### Answer by username_1 on 2018-11-02. Score: 1
  
  I don't think there is such a report. I would probably look at using [Summary Fields extension](https://civicrm.org/extensions/summary-fields) and then adding a new calculated field that does your calculation - and then report on that.
  
  In drupal I would also consider doing this in Views and using eg views\_calc to do the calculation for me instead of creating a calculated field
  
  > **Comments:**
  > **username_0**: I will need to compare 16-17, and 17-18 (etc.) going into the future. It seems like a view offers more flexibility. The other reporting requirement is to ask if they gave the same for X and Y year, but then increased or decreased in Z year.  
  
  ---
  
  