Filter on 2 levels of hierarchy
I'm trying to display on a dashboard a table of company employees (dimension = employee ID, line items are employee characteristics). Each employee is assigned to a SLT member (identified in one of the line items), and each SLT member rolls up to a ELT member in the hierarchy.
That hierarchy looks like
The module I'm using is dimensionalized by the Employee ID and the ELT hierarchy list, with all of the employee characteristics only dimensionalized by Employee ID.
I have some staging lines with both dimensions where I'm identifying the SLT member that is selected, checking if it's a match to the one that employee is assigned to, and creating a filter. That works great for the SLT level of the hierarchy, but I'm trying to make it so that if a user selects ELT1, the filter will show all SLT members who roll up to that ELT member.
I haven't been able to get it to identify which ELT level member is selected without making it a different subsidiary view with that dimension, but when I do that I'm not able to use that line as a filter.
Any suggestions to make it work? Thanks in advance.