2 Replies Latest reply on Sep 23, 2019 12:18 AM by andy garcia

    Drill down to relationship tree

    andy garcia

      Hi,

       

      I would like to build a relationship tree for data in the attached file. From the excel file, it is found that Mary is the direct supervisor of John and Adrianne while John is the supervisor of Amy and Pauline and so on. I would like to build a table with column customerid, customername and sales, with a breakdown where when I click on Mary, it can drill me down to the information of John and Adrianne and when I click on John, it can drill me down to the information of Amy and Pauline.

      Can it be done in Tableau? If yes, please show me how should I setup the dataset and from the dataset how it can be presented in Tableau.