6 Replies Latest reply: Mar 29, 2018 1:26 PM by David Forest RSS

    Filter within one table

    Domini Szybkowski

      Hi, I have the following problem:

       

      I have a simple table with person's ID and hobby, but one person can have many hobbies, so may have many rows. I want to filter on hobby and show bar chart of all hobbies of people, who have filtered hobbies, for instance:

      "Show me hobbies of people who like sports".

       

      But when I create the filter or shows me only sports (as expected). How do I achieve it? It would be a simple sub-query in SQL.

       

      I know I can load the table twice and do the join in ID, but it's not efficient due to table size.

       

      Regards,

      Dominik