Forum Discussion

Lukj's avatar
Lukj
Regular Visitor
7 years ago

Categorizing data for multi-level hierarchy

Hello community,

 

I am experiencing a problem. I hope that the picture below will make my problem clear.

 

Basically i want to make a hierarchy with 3 levels. The first/top level contains only the first letter of the ZKSL column with the text from the OMSCHR column. The second level gets the letter with 2 digits, the third level gets the first 6 of the ZKSL level. Getting the first 1, 3 or 6 entries from the ZKSL column was not hard. The problem is that i want the OMSCHR behind it. As you can see every row only has 1 OMSCHR value.  Eventually every row gets 3 columns for the 3 different hierarchy levels with 3 different OMSCHR values. 

 

  

 

So the third row will eventually look like this:  

 

Would be really great if anyone can help me with this!

 

1 Reply