...
Basically you cannot have one member in more than one Department row-level security role. The way the method is constructed it at this moment not allows one person to participate in more than one department. Same report shows data from the MULTIPLE departments an example non-VIP user is approved to access requirement not met. See following images:
A work around it can be creating Department row-level security roles that can have more than one department . So so we can add multiple users to this role. But this will need further investigation and testing.
See below images with the role containing the Pediatrics department with Pathology:
...