title: OBIEE - Filtering Results based on a "historic" table of values
body: <p>not really sure how/where to ask this so hoping this is the right place.</p>
  <p>I have an OBIEE report that combines two tables; a current status and a 'historic' table.
  I've created an example of my data below:</p>
  <p>[Results of report]</p>
  <p><img src="https://i.stack.imgur.com/J6nRh.png" alt="1" /></p>
  <p>What I'm looking to do is to filter out any serial numbers that have had the status of &quot;appeal&quot; on the claim history dimension. In my image example, it would filter out serial number 5678 completely as at one point it went through the status of &quot;appeal&quot;.</p>
  <p>However, just a quick filter for the status of &quot;appeal&quot; just removes the one line from the report - leaving 5678 on the report but only with the two other statuses it went through (created and refunded).</p>
  <p>Is there a way with a traditional or SQL filter I can remove a serial number completely if it matches my filter criteria?</p>
  <p>Thanks,</p>
  <p>M.</p>