Identifying duplicate emails

Summary:

An analysis that highlights the same emails being registrered to multiple persons

Content (please ensure you mask any confidential information):

I need an OTBI analysis that shows me all emails that are registrered to more than one person, and I have a hard time figuring out how to do it.

I tried using the count function but to no succes.

The analysis just needs to be simple in terms of columns: Legal employer, person number and email. Preferably only showing the ones that are duplicate. An alternative could be to highlight all the ones that are found more than once with a conditional format (like red color or similar).