Forum Discussion
sanjanarama
Resolver I
Resolver Imatrix display for heirarchy
I'm trying to display the heirarchy way to represent data, i have used path method , but im unable to display in visual ID hirachy name parent ID global name 100 Global a null null...
In the matrix visual formatting pane go to Row headers and turn off stepped layout. That should give you the desired view.
sanjanaramaResolver I
Resolver IJirkaZ
I'm not getting desired result
for example if i expand the matrix , it should look like this
| 100 | Global | a | ||
| 105 | Intermediate | f | ||
| 106 | intermediate | g |
JirkaZ
Solution Specialist
Solution SpecialistIn that case create a separate "Level" columns for Level 1, Level 2, Level 3 using the output of the PATH function. For Level 1 you should use PATHITEM(yourpath, 1) etc.
Then you'll have to create a hirearchy in your table (right click on Level 1 and select Create Hierarchy. Then add L2 and L3 to the same hierarchy.
Finally add this hierarchy to your matrix rows area.