1 of 1 people found this helpful
After playing around with your workbook, I was unable to get the function to work. If you're still hoping to get help with this question, I would reach out to support at customer.tableau.com.
I use to build different views for different levels.
I think you can filter by username in custom sql but i'm not sure. It would force you to work in live mode.
If is not possible, i'd build 4 datasources and 4 different views and also would use username or ismemberof to show exactly jus what each user can see.
I hope it helps.