0 Replies Latest reply on Feb 3, 2017 6:12 AM by T M

    How to create a recursive hierarchy in Tableau?

    T M

      Hi everyone.

       

      I have a question regarding creating a recursive hierarchy like the one in the Example.png image below (screenshot from TM1). I'm using middleware to connect TM1 to Tableau via ODBC, and it's capable of saving (or transferring) the hierarchy information from a TM1 cube dimension to Tableau. The problem is that I can only get it formatted like in the Current.png, and I want to make it a drill-down hierarchy like in the Example.png. The goal here would be to get the hierarchy within a single column. Unfortunately I can't attach a packaged workbook due to my company's data policy.

       

      I'm testing this out on MacOS 10.12.2 | Tableau 10.1.3, and Windows Server 2012 R2 | Tableau 10.0.3.

       

      Any help would be much appreciated.

       

      Cheers