I created a calculated field:
If [(Evaluated) Department]=[(Evaluator) Department] then 1 else 0 END
And then filtered out the "1" results. Let me know if that's what you need.
alejandro.twbx 52.1 KB
Alejandro, can you simplify your workbook to only show the problem you are struggling with? I opened your workbook expecting to find a field named 'self-assessment' but didn't see one. So I really don't know how to help you.
Oh, thanks for attaching a workbook! (Just help us focus on the problem, and eliminate everything else.)
Thanks Ailsa. It worked pretty well. I didn´t see how easy you fixed it. I was expecting sonthing else more elaborated
Thanks any way.