Managerial Hierarchy

[cnschulz]

Gday, 

I have a data set with two colums: EmployeeName and ManagerName. This is a recursive structure and *almost* fits the Heirarchy Chart visualisation constraints. The problems I have are:

- The *absolute* top record (the CEO) does not exist so there will be no records that have a NULL in the ManagerName field

- We want to be able to slice this data at any level to look at department/divison/team structures. Again, the top level manager will not have a NULL in the manager field. The manager of this department is managed by someone but they are not in our selection criteria.

I dont really need a visual flowchart as such, an indented (collapsible?) text based list would suffice. 

Does anyone have any experience in this area? 

[cnschulz · Accepted solution]

Finally got around this one. HeirarchySlicer was the answer. It allows you to hide empty nodes, whereas using a "non-blank" filter caused missing records in other slicers.