Display string when field value duplicates

[rrvveerriissssii]

Is there a way to write an expression that will display text when a field value is duplicated?

My report looks like this:

Region Name
North Amy
South John
East Paul
West Amy

I want it to look like this:
Region Name
North Amy (Also at West)
South John
East Paul
West Amy (Also at North)

 

[DaveInIowa]

I think you would need to identify the duplicate Regions in the supporting query.

DECLARE @Table TABLE (Region VARCHAR(16), Name VARCHAR(8))

INSERT INTO @Table VALUES ('North', 'Amy'), ('South', 'John'), ('East', 'Paul'), ('West', 'Amy')

SELECT t.*, Note = '(Also at ' + dup.Region + ')'
  FROM @Table t
 OUTER
 APPLY (SELECT TOP 1 Region
		  FROM @Table
		 WHERE Name = t.Name
		   AND Region <> t.Region) dup

But, what happens when Amy is at a 3rd location?