title: How to extract a list of active stock holdings from a data table using multiple filter criteria?
body: <p>Hopefully, someone can help me. I'm quite stuck for a while now. Thank you for your time!!</p>
  <p><strong>The Goal</strong>:
  Extract a list of active stock holdings from a data table using a function. The holdings are called tickers, the quantity is the number of stocks. The catch is that the filter function must only include the &quot;Buy&quot; and &quot;Sell&quot; options from the &quot;action&quot; column so only the active tickers with a quantity of more than 0 are displayed.</p>
  <p><strong>My current function</strong>:</p>
  <pre><code>=SORT(UNIQUE(FILTER(Degiro_Transactions[Ticker];SUMIF(Degiro_Transactions[Ticker];Degiro_Transactions[Ticker];Degiro_Transactions[Quantity])&lt;&gt;0)))
  </code></pre>
  <p><strong>The problem:</strong>
  My current function lists all tickers and sums the total quantity. Only the active tickers (Buy action + Sell action) should be displayed but I don't know how to do this. So there should be an extra filter that only displays the ticker if the quantity of &quot;Buy&quot; and &quot;Sell&quot; is positive.</p>
  <p>This is the data table:
  [1]: <a href="https://i.stack.imgur.com/UsEFj.png" rel="nofollow noreferrer">https://i.stack.imgur.com/UsEFj.png</a></p>