Answers.Body: <p>Update - the 'Total' feature has been added.</p>
  <p>Tick the 'Show totals in footer' option:</p>
  <p><a href="https://i.sstatic.net/dcp3U.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/dcp3U.png" alt="enter image description here" /></a></p>
  <p>then configure the footer for each column:</p>
  <p><a href="https://i.sstatic.net/aZEim.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/aZEim.png" alt="enter image description here" /></a></p>
  <p>Result:</p>
  <p><a href="https://i.sstatic.net/NVurF.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/NVurF.png" alt="enter image description here" /></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-01-30T16:28:26.153Z
Answers.LastActivityDate: 2023-01-30T16:28:26.153Z
Answers.UserDisplayName: Aidan
Answers.Body: <p>As of this writing SearchKit doesn't have the ability to do a &quot;grand total&quot; style row. You could create one search display that displays each row, and a second search display which shows aggregated totals using GROUP BY, but it can't currently be done within the same search display table.</p>
  <p>However, SearchKit is still in development and new features are being sponsored and added all the time. Hop on <a href="https://chat.civicrm.org/civicrm/channels/search-improvements" rel="nofollow noreferrer">https://chat.civicrm.org/civicrm/channels/search-improvements</a> if you'd like to chip in to sponsor a feature like this!</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-11T14:44:33.670Z
Answers.Text: just to clarify, are you suggesting to add multiple search displays within a single afform? Or have 2 identical queries and each has a display with different GROUP BY settings? I have done the latter option but didn't know if the first was even possible.
Answers.UserDisplayName: zach
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-12T02:17:30.293Z
Answers.Text: Yes you can now add > 1 search display per afform, as of CiviCRM 5.49 (current beta)
Answers.UserDisplayName: Coleman
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-03-09T15:31:20.267Z
Answers.LastActivityDate: 2022-03-09T15:31:20.267Z
Answers.UserDisplayName: Coleman
Body: <p>I've created a few contribution reports using data processor / search kits / afforms for my colleagues.  They work great as my colleagues can quickly see the contributions as well as performing actions on them (sending email, printing acknowledgement letters, etc.).  However, I'm unable to find a way to show the &quot;total contributions&quot; aggregated from all or the filtered results.  My current workaround is to export them into excel to add them up or to run a similar contribution reports, but I wonder if there is a way to show the total contribution directly in data processor output / search kit / afforms?  Any advice is appreciated.  Thanks.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-02-27T18:33:37.123Z
Comments.Text: the way we have achieved this in the past (i suspect SearchKit offers new options) is to use the Summary Fields extension
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-03-02T19:42:33.493Z
Comments.Text: Are you looking for something like a "Grand Total" line at the bottom?
Comments.UserDisplayName: Coleman
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-03-08T22:29:53.540Z
Comments.Text: Hi @Coleman,
  Yes, I'm looking for a way to show the Grand Total.  I've tried the summary fields, but I'm unable to (or I haven't figured out a way to) show the grand total through the summary fields.  Any guidance is appreciated.
  
  PS~ I'm able to pull regular / extended reports to show the grant total, but my colleague really like the SearchKit / Data Process interface, where they can perform actions on the records (primarily printing / emailing receipts and sending other email correspondence).
Comments.UserDisplayName: Aaron
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-03-22T18:59:47.283Z
Comments.Text: I expect that feature will be coming soon from SearchKit. There's been new sponsorship.
Comments.UserDisplayName: Coleman
Tags: <searchkit><data-processor>
Title: Show "total contributions" from all results in data processor or search kit?
ThreadText: # Show "total contributions" from all results in data processor or search kit?
  
  (Asked by: username_0 on 2022-02-27)
  
  I've created a few contribution reports using data processor / search kits / afforms for my colleagues. They work great as my colleagues can quickly see the contributions as well as performing actions on them (sending email, printing acknowledgement letters, etc.). However, I'm unable to find a way to show the "total contributions" aggregated from all or the filtered results. My current workaround is to export them into excel to add them up or to run a similar contribution reports, but I wonder if there is a way to show the total contribution directly in data processor output / search kit / afforms? Any advice is appreciated. Thanks.
  
  **Tags:** searchkit, data-processor
  
  > **Comments:**
  > **username_1**: the way we have achieved this in the past (i suspect SearchKit offers new options) is to use the Summary Fields extension  
  > **username_2**: Are you looking for something like a "Grand Total" line at the bottom?  
  > **username_0**: Hi @username_2, Yes, I'm looking for a way to show the Grand Total.  I've tried the summary fields, but I'm unable to (or I haven't figured out a way to) show the grand total through the summary fields.  Any guidance is appreciated.  PS~ I'm able to pull regular / extended reports to show the grant total, but my colleague really like the SearchKit / Data Process interface, where they can perform actions on the records (primarily printing / emailing receipts and sending other email correspondence).  
  > **username_2**: I expect that feature will be coming soon from SearchKit. There's been new sponsorship.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_3 on 2023-01-30. Score: 3
  
  Update - the 'Total' feature has been added.
  
  Tick the 'Show totals in footer' option:
  
  [![enter image description here](https://i.sstatic.net/dcp3U.png)](https://i.sstatic.net/dcp3U.png)
  
  then configure the footer for each column:
  
  [![enter image description here](https://i.sstatic.net/aZEim.png)](https://i.sstatic.net/aZEim.png)
  
  Result:
  
  [![enter image description here](https://i.sstatic.net/NVurF.png)](https://i.sstatic.net/NVurF.png)
  
  
  ---
  
  ### Answer by username_2 on 2022-03-09. Score: 2
  
  As of this writing SearchKit doesn't have the ability to do a "grand total" style row. You could create one search display that displays each row, and a second search display which shows aggregated totals using GROUP BY, but it can't currently be done within the same search display table.
  
  However, SearchKit is still in development and new features are being sponsored and added all the time. Hop on <https://chat.civicrm.org/civicrm/channels/search-improvements> if you'd like to chip in to sponsor a feature like this!
  
  > **Comments:**
  > **username_4**: just to clarify, are you suggesting to add multiple search displays within a single afform? Or have 2 identical queries and each has a display with different GROUP BY settings? I have done the latter option but didn't know if the first was even possible.  
  > **username_2**: Yes you can now add > 1 search display per afform, as of CiviCRM 5.49 (current beta)  
  
  ---
  
  