...
- Same report shows data from the MULTIPLE departments an example non-VIP user is approved to access requirement not met.
A work around it can be creating Department row-level security roles that can have more than one department. So we can add multiple users to this role.
See below images with the role containing the Pediatrics department with Pathology:
...