0 Replies Latest reply on Mar 11, 2013 11:34 AM by Vaçe Küpecioğlu

    Filtering rows containing a specific value

    Vaçe Küpecioğlu

      Hello,

       

      I have only 3 columns: Chain ID, Letter and Order. As data, I have one chain containing the letter 'A', one chain containing the letter 'B' and one chain containing the letter 'A' and 'B'. So in table, it looks like the following:

      all_chains.PNG

      What I want to do is to create a filter containing the letters ('A' and 'B') so that when I choose 'A', it only shows the chains containing the letter 'A'. But I still want to see other letters in the resulting chains. So I want the result look like this:

      as_is_sould_be.PNG

       

      When I use letter dimension in the filter drawer, it filters all the cells resulting:

      as_i_get_it.PNG

      So how can I change the filters scope from cell to row? Or is there another way to achieve what I want?

       

      Thank you.