Forum Discussion
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
- DataInsightsSuper User
Hello, were you able to resolve this?