Body: <p>We have several reports that involve quantities (resources purchased, donations, participant attendance, etc) and we would like to be able to sum all values in a column. I haven't found a quick way to do this for a SearchKit report. Our current method usually involves an export and then manipulating the data in Excel. We are trying to find ways to keep our users in Civi rather than working in spreadsheets.</p>
  <p><a href="https://i.sstatic.net/fUHjd.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/fUHjd.png" alt="enter image description here" /></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-03-10T15:39:21.440Z
Comments.Text: Just to be clear: you want this break-down as well as a total?  If so, see https://civicrm.stackexchange.com/a/41425/225
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-03-10T16:37:07.777Z
Comments.Text: @Aidan, thanks for the link. That's exactly what I'm looking for. I will keep an eye out for this feature to be added. It is more of a "wish list" item for us so it's not super pressing. Thanks again.
Comments.UserDisplayName: zach
Tags: <reports><searchkit><formbuilder>
Title: Needing a way to sum a column in a searchkit report
ThreadText: # Needing a way to sum a column in a searchkit report
  
  (Asked by: username_0 on 2022-03-10)
  
  We have several reports that involve quantities (resources purchased, donations, participant attendance, etc) and we would like to be able to sum all values in a column. I haven't found a quick way to do this for a SearchKit report. Our current method usually involves an export and then manipulating the data in Excel. We are trying to find ways to keep our users in Civi rather than working in spreadsheets.
  
  [![enter image description here](https://i.sstatic.net/fUHjd.png)](https://i.sstatic.net/fUHjd.png)
  
  **Tags:** reports, searchkit, formbuilder
  
  > **Comments:**
  > **username_1**: Just to be clear: you want this break-down as well as a total?  If so, see https://civicrm.stackexchange.com/a/41425/225  
  > **username_0**: @username_1, thanks for the link. That's exactly what I'm looking for. I will keep an eye out for this feature to be added. It is more of a "wish list" item for us so it's not super pressing. Thanks again.  
  
  ---
  
  ## 0 answers
  
  