Answers.Body: <p>The Aggregated Household Contributions extension by Allen Shaw at Emphanos will get you close. It creates a report template for the Contribution Aggregate by Relationship report. The report will show up to 5 years of history by year (you can choose to show less) and a total if you want it. However by default it groups contacts into households, shows the contributions for the individuals in the household, and then shows the total for the household by each year (which is actually a really nice thing to have). If someone is not in a household, it will just show the individual giving history. If you don't know how to load extensions, you can reach out to your sys admin or post another question.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-16T23:02:10.963Z
Answers.Text: https://civicrm.org/extensions/aggregate-household-contributions-report
Answers.UserDisplayName: Allen Hutchison
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-16T22:48:55.293Z
Answers.LastActivityDate: 2016-02-16T22:59:00.317Z
Answers.LastEditDate: 2016-02-16T22:59:00.317Z
Answers.UserDisplayName: guyiac
Answers.Body: <p>Mary, I do not think there is a standard report that does that. You could create a customized report (or ask a CiviCRM partner to do it for you) that shows the data like you explain. 
  And I agree with the suggestion that petednz made about Drupal Views.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-16T07:13:50.687Z
Answers.LastActivityDate: 2016-02-16T07:13:50.687Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>I am the Treasurer of small not-for-profit organization and we use CIVI for our donations database.  I see that CIVI has a "Repeat Contributions" report that can show a comparison of total $$ donated amount by person for two consecutive years.  This is good; however, I would like to see ONE report that lists the total donations for each person for our 5 years; that is, think ....column A has the name, and Columns B,C,D,E,F shows the annual contribution amount for that year.  Can this be done?  and if so, how?
  Thank you - Mary - (Treasurer)     </p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-16T01:16:10.530Z
Comments.Text: Mary - if you don't get a good answer for doing this via civi reports, then if you are using Drupal there could be a Views alternative solution.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-16T19:32:23.317Z
Comments.Text: Let me know if you are on drupal and i can provide more guidance as i expect it may require views_field_view module to pull year specific data in to each column
Comments.UserDisplayName: petednz - fuzion
Tags: <reports>
Title: is a certain report available?
ThreadText: # is a certain report available?
  
  (Asked by: username_0 on 2016-02-15)
  
  I am the Treasurer of small not-for-profit organization and we use CIVI for our donations database. I see that CIVI has a "Repeat Contributions" report that can show a comparison of total $$ donated amount by person for two consecutive years. This is good; however, I would like to see ONE report that lists the total donations for each person for our 5 years; that is, think ....column A has the name, and Columns B,C,D,E,F shows the annual contribution amount for that year. Can this be done? and if so, how?
  Thank you - username_0 - (Treasurer)
  
  **Tags:** reports
  
  > **Comments:**
  > **username_1**: username_0 - if you don't get a good answer for doing this via civi reports, then if you are using Drupal there could be a Views alternative solution.  
  > **username_1**: Let me know if you are on drupal and i can provide more guidance as i expect it may require views_field_view module to pull year specific data in to each column  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2016-02-16. Score: 3
  
  The Aggregated Household Contributions extension by Allen Shaw at Emphanos will get you close. It creates a report template for the Contribution Aggregate by Relationship report. The report will show up to 5 years of history by year (you can choose to show less) and a total if you want it. However by default it groups contacts into households, shows the contributions for the individuals in the household, and then shows the total for the household by each year (which is actually a really nice thing to have). If someone is not in a household, it will just show the individual giving history. If you don't know how to load extensions, you can reach out to your sys admin or post another question.
  
  > **Comments:**
  > **username_3**: https://civicrm.org/extensions/aggregate-household-contributions-report  
  
  ---
  
  ### Answer by username_4 on 2016-02-16. Score: 2
  
  username_0, I do not think there is a standard report that does that. You could create a customized report (or ask a CiviCRM partner to do it for you) that shows the data like you explain.
  And I agree with the suggestion that petednz made about Drupal Views.
  
  
  ---
  
  