Answers.Body: <p>I was able to do this via a contribution summary report - unfortunately that does not allow for sorting. </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-06-13T17:57:14.227Z
Answers.LastActivityDate: 2019-06-13T17:57:14.227Z
Answers.UserDisplayName: themak
Body: <p>I am looking to be able to build a report that essentially has aggregate donations grouped by a custom field.  For example - every donor is asked: How did you hear about us (Referral Source), which is answered via a contribution custom field set of options.  Essentially we want to create a report that says:</p>
  
  <p>Referral Source - Number of Donations - Total Donations - Average Donations</p>
  
  <p>Is there a report that can let me do that - is there an extension that provides such a capability?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-06-13T19:58:20.513Z
Comments.Text: You could look at extending Summary Fields https://civicrm.org/extensions/summary-fields
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-11-02T19:27:09.997Z
Comments.Text: You could do it in search kit I think
Comments.UserDisplayName: eileen
Tags: <civireport><custom-reports>
Title: Contribution Report - Grouped by Custom Field
ThreadText: # Contribution Report - Grouped by Custom Field
  
  (Asked by: username_0 on 2019-06-13)
  
  I am looking to be able to build a report that essentially has aggregate donations grouped by a custom field. For example - every donor is asked: How did you hear about us (Referral Source), which is answered via a contribution custom field set of options. Essentially we want to create a report that says:
  
  Referral Source - Number of Donations - Total Donations - Average Donations
  
  Is there a report that can let me do that - is there an extension that provides such a capability?
  
  **Tags:** civireport, custom-reports
  
  > **Comments:**
  > **username_1**: You could look at extending Summary Fields https://civicrm.org/extensions/summary-fields  
  > **username_2**: You could do it in search kit I think  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2019-06-13. Score: 0
  
  I was able to do this via a contribution summary report - unfortunately that does not allow for sorting.
  
  
  ---
  
  