I need to filter a slice based on the equality of one of the columns with the specific value of another two column of another table, based on the user’s record. I tried the following:
AND([TenantRole] = “Residente”, [TenantLocal] = TEXT(LOOKUP(USEREMAIL(), “Tenant”, “TenantId”, “TenantLocal”)))
But it did not work.
Any idea?
Ply healp me correting my expression
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |