We have a DFF on Departments called Dept Level - represented in the yellow node.
There are cases where some level is missing, e.g. CCD has a L5 dept TTT underneath, and there is no L4 dept.
We are using BI Publisher data model which combines DFF and Dept Tree to get the 'custom' hierarchy
How can we build a visual like the one shown above?