Exclude logged in user from indirect reports
Summary
Exclude logged in user from indirect reportsContent
Hi,
I have a Direct and Indirect selector prompts for managers to use which displays direct and indirect employees. the problem I have is the manager who would loin and view the report is showing themselves as an indirect employee.
I have tried the following to remove the user but my Syntax is not working.
CASE WHEN "Worker"."Employee Name" = USER() THEN <> USER() END
For example
If I view select 'Direct' it will view my direct reports and I will see the following;
-Steve
-Bob
-Sue
If I select Indirect I can see my indirect reports but I can also see myself.
0