Forum Discussion

romeo95's avatar
romeo95
Frequent Visitor
8 years ago

hierarchical visualization

Hi to everybody, I write you to ask you a suggestion: I have a chart with the business structure, 2 columns with code structure and code it structures superior, like this UNIT    UNIT FATHER 1     ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi romeo95,

 

Please create a one to one relationship between these two tables based on [UNIT].

 

Add corresponding fields into chart visual. You can view hierarchical data by clicking the drill down icon.

 

Best regards,
Yuliana Gu

  • romeo95's avatar
    romeo95
    Frequent Visitor
    8 years ago

    hi, I thank you but the solution is not that that I look for, in my scheme 3 are father of 6 but child of 1 but in the visualization it results to the same level of 1 and 2

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      8 years ago

      Hi romeo95,

       

      Then, what is your desired output?

       

      Regards,
      Yuliana Gu

      • romeo95's avatar
        romeo95
        Frequent Visitor
        8 years ago

        Hi Yuliana Gu,

        I desidere something like this

        UNIT  SALES
            
        1  10
         3 8
          611
         SUBTOTAL 19
         4 26
         SUBTOTAL 26
        SUBTOTAL 55
        2  13
         5 9
         SUBTOTAL 9
        SUBTOTAL 22
        TOTAL  77

         

        practically the same result that I would get through an oracle Hierarchical Query