Forum Discussion
Boss/employee segmenter
Hello good afternoon, what I want you to do is that if you select a user bring all the subordinates and the subordinates of their subordinates, until you reach the person without subordinates
Hi,
The PARCHCONTAINS() function should work. For more specific help, share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.
Event Event Description Sorter Classification Status Research Research Leader Research Status Action Action Description Responsible Statement of Action 1 - 200 Classified 1 201 Investigated 1 - 202 Made 1 - 200 Classified 1 201 Investigated 2 - 200 Made 2 - 201 Not Classified 3 - 202 Classified 3 200 Not Investigated 4 - 200 Classified 4 201 Investigated 3 - 202 Made 4 - 200 Classified 4 201 Investigated 4 - 202 Earring 4 - 200 Classified 4 201 Investigated 5 - 201 Earring 5 - 201 Classified 5 202 Investigated 6 - 200 Made 5 - 201 Classified 5 202 Investigated 7 - 200 Made 5 - 201 Classified 5 202 Investigated 8 - 201 Made 5 - 201 Classified 5 202 Investigated 9 - 202 Earring 5 - 201 Classified 5 202 Investigated 10 - 200 Earring User Code User Boss Code 200 So-and-so - 201 Stuttgart 200 202 Pepito 201 Due to confidentiality issues I cannot upload the original tables. By way of example, these would be these. The objective would be if I select So-and-so to see all the data in three different visuals one for events, one for research and one for actions, if I select So-and-so to see only his data and Pepito's. And finally, if Pepito was selected, only see his data.
Sorry for the data in this way but it did not let me load excel or power bi.
Sorry but cannot understand anything there.