Hello,
I have set up RLS for different departments. The CEO should be able to view all department's performances. When I tested out his role, he was able to. He has been able to see all departments the past week. However, this week, for some reason he can only filter for only one department. The others do not show up. Even though when I test out his role, it does give him the ability to filter for each department. Can somebody please tell me what might be going wrong here?
