From the List of values I have some duplicates in EmpId but emp name list is coming as upper or full name for the duplicate Empid. (Please see Attached)
In an webi cell, i wanted to show the list of emp names without any duplicates in EmpId
any one of the Empname if it shows for that duplicate unique id is fine.
Please assist with an formula to display list of EmpNames for the unique EmpId.