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?
Maybe I am missing something.
But if you have a filter for Supervisor Name when you select one of them you will then see the employees associated with them by default. That is what Qlik does.
LOAD * INLINE [
HIERARCHY([Employee], [Supervisor], [Employee Desc], [Employee Parent Name], [Employee Desc], [Hierarchy Employee], '/', 'Employee Hierarchy depth')
Employee as [Employee Desc]
DROP TABLE Temp;