Sum/group by function in workforce compensation plan column

Summary: We have a requirement where we need to redistribute the bonus percentage payout and normalize the bonus percentage so that the sum of bonus percentage of all employees always equals 100% of allocated total bonus amount for that group of employees.

Content (required):

Below is the scenario,

Let's consider a particular Business unit 'XX' and the total bonus amount allocated to this BU is 10000. There are four employees within this BU who are eligible for the bonus. Each of these employee will have target bonus amount and the final bonus amount for each employee will be determined based on the performance of employee.