title: Tableau - Filter via cell with multiple values
body: <p>So I have data like the below. If I add the example of state as a filter with the below data I'll simply have 3 options to select from. Instead I'm trying to create a filter that simply lists all available options. </p>
  
  <p>Quick Edit: Yes I have considered using a Parameter, however I need the filter to be multi select which parameters do not offer.</p>
  
  <pre><code>State
  NY
  PA
  FL
  SC
  NC
  WV
  TX
  CA
  
  ID | State
  1  | PA, NY, FL, SC
  2  | CA, WV, PA, NY
  3  | NC, SC, TX, FL, NY
  </code></pre>
  
  <p>Second Edit:</p>
  
  <p>I do not have the ability to reshape this data due to the potential number of options per column that I need to filter on, (75+ on at least two). Which is why I'm asking this question. I was hoping there might be a solution similar to SSRS where I can populate my filter with Query B and use the results to filter back to Query A.</p>