2 Replies Latest reply on Feb 11, 2017 7:23 AM by Ivar Arnarsson

    Import organizational structure that has names and values, into Tableau.

    Ivar Arnarsson

      Hello,

       

      I have data in excel which is the hierarchy of a company (company name, department, sub-department, etc), each line also includes code/value for each department that needs to be linked to the name.

       

      I've imported the data, grouped the dimensions into a hierarchy. When i expand the hierarchy e.g. in the rows/columns, i get the bad matrix with nulls.

       

      My dream outcome is to create a hierarchical dimensions (just like i expand year into quarters etc.) linked to the department codes. I'm then doing to connect this sheet to another datasheet that has also department codes.

       

      I've been stuck on this for a couple of days. I've included the datasheet. Can anyone guide me with this?