How to avoid duplicate values in reporting

Content

Hello experts,

I have created a custom report where for each employee there is an assigned goal. Moreover, there is also a Bonus column but its value is duplicated. In other words this value appears for each goal. For example, if an employee has five goals; i will get five rows in the report and bonus value is repeated five times. The expected outcome should be to get one value only for all goals. How can I merge that column in order to have a unique value?

Thanks in advance for your time!

Regards,

Valerio