4 Replies Latest reply: Feb 8, 2018 12:12 PM by Neetha Thomas RSS

    Multiple Field values in Single filter- How can we make it associative

    Neetha Thomas

      Hi,

       

      I have 3 columns Column A, Column B, Column C residing in same table. I need to create a filter with the distinct values of this 3 columns, and when I apply filter or select any particular value which belongs to Column A, the data should get filtered based on only Column A. Is this can be achieved?

       

        Source Table

      ABCDEFG
      aa1bb1cc1deerweok
      aa2bb1cc2deertdfjk
      aa2bb1cc2dsytvbhjg
      aa3bb2cc3dgfdkjlww

       

      Filter Needed in below format:

      aa1

      aa2

      aa3

      bb1

      bb2

      cc1

      cc2

      cc3

      Output :

      In the filter if I select value aa1, only the first row should get displayed.