title: How to create intersection data in Tableau
body: <p>I have a problem that I need to solve which is somewhat simplistic but I can't work it out. Any help is much appreciated.</p>
  
  <p>ok. I have a dataset of a million records:</p>
  
  <pre><code>TransId, PersonGUID, Origin.
  </code></pre>
  
  <p>Origin has 2 options: [Credit, Current]</p>
  
  <p>Now, I need to filter down to only those transactions where a PersonGUID has had both at least 1 row in Credit and Current.</p>
  
  <p>I can do this somewhat easily in PythonPandas and load in the CSV but I don't want 2 datasets as I'll be building a dashboard around ALL data.</p>
  
  <p>I am guessing a boolean logic calculated field but I can't work it out. </p>
  
  <p>Thanks</p>
  
  <p>Rob</p>