Display slice that matches all [Sector] and if USERNAME()=[Email] and Access Level = Lead
So Im trying to give access to all "Lead" role that they can see all details based on sector
1. Create slice for that table and name it as 'Current User'. The filter condition would be [Email] = USEREMAIL()
2. Go to your desired view and put this expression in the Show_If
AND(
INDEX(Current User[Sector], 1) = "Group 1",
INDEX(Current User[AccessLevel], 1) = "Lead"
)
Can I set a username filter condition?
User | Count |
---|---|
19 | |
10 | |
7 | |
5 | |
5 |