Is it possible to create a drill down based off of only the supervisor name
|Employee Name||Supervisor Name|
I want to start with John drill into Paul and Mike, if click Mike receive Chris and Rob and if click Paul receive Dylan and Lisa. Is this possible?
LOAD * INLINE [
HIERARCHY([Employee], [Supervisor], [Employee Desc], [Employee Parent Name], [Employee Desc], [Hierarchy Employee], '/', 'Employee Hierarchy depth')
Employee as [Employee Desc]
DROP TABLE Temp;