Forum Discussion
Resolver Imatrix display for heirarchy
In the matrix visual formatting pane go to Row headers and turn off stepped layout. That should give you the desired view.
Solution SpecialistYou should just be able to put both columns (ID and Parent ID) into the same row field of the matrix visual. The hierarchy should be created automatically.
sanjanaramaJirkaZ
I'm not getting desired result
for example if i expand the matrix , it should look like this100 Global a 105 Intermediate f 106 intermediate g - JirkaZ
In 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.
- sanjanarama
JirkaZ
this is how I am getting into- JirkaZ
Seems to be correct