I have a table REGISTER of action items with an [Owner] column ref to another table call OWNERS
The OWNERS table has the columns [Email], [Name], and [Login]
Since some users are using a Gmail account to Login different than the email on the action item list, I have modified the slice Filter on REGISTER table from: [Owner] = USEREMAIL() to
LOOKUP(USEREMAIL(),โOwnersโ,โLoginโ,โEmailโ) = [_THISROW].[Owner]
But it is not working.
I have also tried [_THISROW].[Owner].[Login] = USEREMAIL() but with no success
Thanks for your help.
#################
UPDATE: I found the error: I had a security filter on the OWNERS tableโฆ
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |