Answers.Body: <p>I think what you want can be accomplished by filtering out transactions with an incomplete status, like this:
  <a href="https://i.sstatic.net/OjahH.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/OjahH.png" alt="enter image description here" /></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-09-08T07:04:04.820Z
Answers.Text: Thanks. This really helped!
Answers.UserDisplayName: avall-llovera
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-09-06T14:47:40.417Z
Answers.LastActivityDate: 2022-09-06T14:47:40.417Z
Answers.UserDisplayName: Coleman
Body: <h1><strong>What we want</strong></h1>
  <p>We want to have a Search that shows us the upcoming Events with the Total Amount paid for each event. Something like this:</p>
  <p><a href="https://i.sstatic.net/vZhIY.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/vZhIY.png" alt="enter image description here" /></a></p>
  <h1><strong>Our problem</strong></h1>
  <p>While listing the upcoming events is easy, showing what our Partipants paid for them is quite troublesome.</p>
  <p>To be able to show what the Participants paid, we have to do it via Line Items. We constructed our Search like the following one:</p>
  <p><a href="https://i.sstatic.net/pxEf2.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/pxEf2.png" alt="enter image description here" /></a></p>
  <p>What this Search shows is what the Participants should have paid, but not what actually paid.</p>
  <p>For example, an event costs 100€, but the Participant only paid 80€. This search would add the 100€ instead the real 80€.</p>
  <p>Our question is, how we can add the real amount instead of the cost of the event?</p>
  
Tags: <civievent><searchkit><line-items>
Title: Search Kit - List of Events with their real total amounts
ThreadText: # Search Kit - List of Events with their real total amounts
  
  (Asked by: username_0 on 2022-09-06)
  
  # **What we want**
  
  We want to have a Search that shows us the upcoming Events with the Total Amount paid for each event. Something like this:
  
  [![enter image description here](https://i.sstatic.net/vZhIY.png)](https://i.sstatic.net/vZhIY.png)
  
  # **Our problem**
  
  While listing the upcoming events is easy, showing what our Partipants paid for them is quite troublesome.
  
  To be able to show what the Participants paid, we have to do it via Line Items. We constructed our Search like the following one:
  
  [![enter image description here](https://i.sstatic.net/pxEf2.png)](https://i.sstatic.net/pxEf2.png)
  
  What this Search shows is what the Participants should have paid, but not what actually paid.
  
  For example, an event costs 100€, but the Participant only paid 80€. This search would add the 100€ instead the real 80€.
  
  Our question is, how we can add the real amount instead of the cost of the event?
  
  **Tags:** civievent, searchkit, line-items
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-09-06. Score: 4 | Accepted answer
  
  I think what you want can be accomplished by filtering out transactions with an incomplete status, like this:
  [![enter image description here](https://i.sstatic.net/OjahH.png)](https://i.sstatic.net/OjahH.png)
  
  > **Comments:**
  > **username_0**: Thanks. This really helped!  
  
  ---
  
  