title: How to create an exclusion filter set in Tableau
body: <p>I am working in Tableau and trying to figure out how to create a filter exclusion.  For example I have the following fields.</p>
  
  <p>Hospital    CallType    CallDate</p>
  
  <p>I want to filter out all hospitals where one of the Calls has a call type of ColdCall and a Call DateBetween X and Y.</p>
  
  <p>I can do this easily in SQL but don't have access to this data in the SQL Database.  It would be the following:</p>
  
  <pre><code>Select
  Hospital
  ,CallType
  ,CallDate
  Into
  #TempTable
  From
  Database
  
  Select
  Hospital
  ,CallType
  ,CallDate
  Into
  #ExclusionTable
  From
  Database
  Where
  CallType = 'Cold'
  and
  CallDate Between X and Y
  
  Select
  Hospital
  ,CallType
  ,CallDate
  From
  #TempTable
  Where
  Hospital not in
  (Select
  Hospital
  From
  #ExclusionTable)
  </code></pre>
  
  <p>Any suggestions would be greatly appreciated.</p>
  
  <p>Thanks,</p>