title: How do I filter my states columns against a East/West parameter?
body: <p>I have a report that has a column with different states. How do I filter those states from my parameter that has just East and West instead of individual states?</p>
  
  <p>My query for state list is:</p>
  
  <pre><code>select distinct
  state
  from contract
  </code></pre>
  
  <p>my query for parameter is:</p>
  
  <pre><code>select distinct
  case when  STATE = 'CA' or STATE = 'WA' or STATE = 'MO'
          or STATE = 'OR' or STATE = 'NV' or STATE = 'ID'
          or STATE = 'MT' or STATE = 'WY' or STATE = 'UT'
          or STATE = 'AZ' or STATE = 'CO' or STATE = 'NM'
          or STATE = 'ND' or STATE = 'SD' or STATE = 'NE'
          or STATE = 'KS' or STATE = 'OK' or STATE = 'TX'
          or STATE = 'LA' or STATE = 'AR' or STATE = 'IA'
          or STATE = 'MN' or STATE = 'HI' or STATE = 'AK' then 'West'
  
      when   STATE = 'MI' or STATE = 'OH' or STATE = 'PA'
          or STATE = 'NJ' or STATE = 'WI' or STATE = 'IL'
          or STATE = 'IN' or STATE = 'KY' or STATE = 'TN'
          or STATE = 'MS' or STATE = 'AL' or STATE = 'GA' 
          or STATE = 'FL' or STATE = 'SC' or STATE = 'NC'
          or STATE = 'VA' or STATE = 'WV' or STATE = 'MD'
          or STATE = 'DE' or STATE = 'CT' or STATE = 'RI' 
          or STATE = 'NY' or STATE = 'MA' or STATE = 'VT'
          or STATE = 'NH' or STATE = 'ME'  then 'East'
      else null end as 'Territory Selection'
  from contracts
  </code></pre>
  
  <p>My parameter would show up as [All][West][East]. I thought if I set my filter as [State] IN [Territory Selection] it would filter the states as belonging to east or west but it's not working as expected. Any pointers would be appreciated!</p>