4 Replies Latest reply on Aug 23, 2016 9:35 AM by Obaidur Rahman

    Need to solve a hierarchy tree challenge.

    Obaidur Rahman

      I have two tables. table 1 contains group level i.e.

       

                                                                                                                                                                                    

      Group 1
      Group 1.1
      Group 1.1.1
      Group 1.1.1.1
      Group 1.1.1.2
      Group 1.1.2
      Group 1.1.3
      Group 1.1.4
      Group 1.2
      Group 1.2.1
      Group 1.2.2
      Group 1.2.2.1
      Group 1.2.3
      Group 1.2.4
      Group 1.3
      Group 1.3.1
      Group 1.3.2
      Group 1.3.3
      Group 1.3.4
      Group 1.3.5
      Group 1.4
      Group 1.4.1

       

      and the second table contains something like following:
                       
      Group 1.1.1.1Item 1
      Group 1.1.2Item 2
      Group 1.1.2Item 3
      Group 1.1.2Item 4
      Group 1.2.2.1Item 5
      where Item 1 belongs to any group
      Group 1
      Group 1.1
      Group 1.1.1
      Group 1.1.1.1

       

      Need to find a way to generate a report when I select a group it provides me all the subgroups and its items. My database is Postgres and I am using Tableau desktop profession v9.3.

       

      Thanks.