title: Filter out rows in a DataSet based on unique ID and distinct child parameter
body: <p>I have a <strong>DataSet</strong> dsInvoiceData that contains the fields "ACTIVITY", "LOGUID", "VALUE".</p>
  
  <p><strong>Example</strong> of problem Dataset:</p>
  
  <pre><code>ACTIVITY-----LOGUID-----VALUE
  </code></pre>
  
  <hr>
  
  <pre><code>MOVE  ------- AAAAAA ----- 000000
  
  STORE ------- AAAAAA ----- 111111
  
  STORE ------- AAAAAA ----- 222222
  
  STORE ------- AAAAAA ----- 333333
  
  MOVE  ------- BBBBBB ----- 000000
  
  STORE ------- BBBBBB ----- 222222
  </code></pre>
  
  <hr>
  
  <p><strong>How can I create a new DATASET (from the current one)?</strong> </p>
  
  <p>which only contains rows:</p>
  
  <p><code>(WHERE VALUE = 000000)</code></p>
  
  <p>OR </p>
  
  <p><code>(IF (VALUE != 000000) AND (each LOGUID can only have DISTINCT ACTIVITY))</code></p>
  
  <p><strong>Example</strong> of Result, Dataset should be:</p>
  
  <pre><code>ACTIVITY-----LOGUID-----VALUE
  </code></pre>
  
  <hr>
  
  <pre><code>MOVE  ------- AAAAAA ----- 000000
  
  STORE ------- AAAAAA ----- 111111
  
  MOVE  ------- BBBBBB ----- 000000
  
  STORE ------- BBBBBB ----- 222222
  </code></pre>
  
  <hr>