4 Replies Latest reply on Jun 14, 2018 9:44 AM by Domagoj Culinovic

    Hierarchy drill down from table structure

    Domagoj Culinovic

      I am looking for best tip how to enable Hierarchy drill down from this table:

      Level1

           Level2

                Level3

                     Level4

      Please let me know the bet way i can do that!

          

      IDCodeCategoryLevelParentCategoryID
      10 ALL Category1NULL
      20NCategory Type 0121
      30PCategory Type 0221
      400Group0032
      501Group0133
      602Gropu0233
      703Group0332
      804Group0433
      905Group0533
      1006Group0632
      11023Subgroup0144
      12028SubGroup0244
      13030SubGroup0344
      14115SubGroup04410
      15027SubGroup0545
      16029SubGroup0645
      17211SubGroup0745
      18202SubGroup0846
      19212SubGroup0946
      20317SubGroup1047
      21318SubGroup1147
      22402SubGroup1248
      23404SubGroup1348
      24405SubGroup1448
      25406SubGroup1548
      26210SubGroup1649
      27508SubGroup1749
      28509SubGroup1849
      29116SubGroup19410
      30407SubGroup2048
      310230Detail 01511
      3202301Detail 02511
      3302302Detail 03511
      340270Detail 04515
      35027030Detail 05515
      360280Detail 06512
      370300Detail 07513
      38030001Detail 08529
      39030002Detail 09529
      40030003Detail 10529
      41030004Detail 11529
      42030005Detail 12529
      43030006Detail 13529
      44030011Detail 14529
      45030030Detail 15513
      46030031Detail 16513
      47030032Detail 17513
      48030033Detail 18513
      49030034Detail 19513
      50030035Detail 20513
      51030036Detail 21513
      52030037Detail 22513
      53030038Detail 23513
      54030039Detail 24513
      55030040Detail 25513
      56030041Detail 26513
      57030042Detail 27513
      58030043Detail 28513
      59030050Detail 29513
      60030051Detail 30513
      61030052Detail 31513
      62030053Detail 32513
      63030057Detail 33513
      64030058Detail 34513
      65030059Detail 35513
      66030060Detail 36513
      67030070Detail 37513
      68030081Detail 38513
      69030091Detail 39513
      700301Detail 40513
      710302Detail 41513
      721150Detail 42514
      73115010Detail 43529
      74115030Detail 44514
      75115031Detail 45514
      76115050Detail 46514
      77115060Detail 47514
      78115070Detail 48514
      79115080Detail 49514
      80115090Detail 50514
      812010Detail 51522
      82201010Detail 52529
      83201011Detail 53529
      84201012Detail 54529
      85201013Detail 55529
      86201061Detail 56522
      87201064Detail 57522
      88201070Detail 58522
      89201071Detail 59522
      90201072Detail 60522
      91201073Detail 61522
      92201074Detail 62522
      93201075Detail 63522
      94201076Detail 64522
      95201081Detail 65522
      96201085Detail 66522
      97201086Detail 67522
      98201091Detail 68522