Forum Discussion

MOUNICA_BV's avatar
MOUNICA_BV
Frequent Visitor
1 year ago
Solved

Manager to employee filtering using slicer

Hi,

I have come across a requirement where 

I have table with empid,empname,managerid
So in report I will show 3 columns in a table and a slicer based on empid.
Now when I select one empid, the respective row will be shown in table but when I choose an empid who is also a manager then all employees under him also should be shown in the table.some employees are top-level,they don't have a manager.
 
Please let me know how to implement this. 
 
sample data
Empid  Empname Managerid
100       Abc
101       XYZ              100
102       MMM           100
104       DDD            106
105       EEE              106
106       KKK 




3 Replies