1 Reply Latest reply on Mar 29, 2018 11:45 AM by Deepak Rai

    Filter via cell with multiple values

    Evan Knofsky

      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.

      I have considered using a Parameter, however I need the filter to be multi select which parameters do not offer.

      Unfortunately 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.

      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