Slices - Double Edge Lookup

[Domearian]

I currently use this to filter a slice of DOB DATA:

AND([Status]="Open",[USEREMAIL]=USEREMAIL())

[Status]="Open" - A Dob that is currently Open [USEREMAIL]=USEREMAIL() - The users email address which was used to create the DOB,

I want to now use the above but want the ability for managers to see ALL open status items. So if a manager, who is assigned as a "Manager", I want that to overrule the [USEREMAIL]=USEREMAIL() part. Hope that makes sense.

The manager is assign in a datasource called [User Administration], and the colum in question to assign as a manager is [Manager?]. So a user has an email address, and if the email matches the USEREMAIL, they get assign a manager.

[Nomartkd]

Not sure if this would help.

and([Status]="Open",OR([USEREMAIL]=USEREMAIL(),LOOKUP(USEREMAIL(),"USER ADMINISTRATION","USERMAIL","MANAGER?")="Y"))