How to create a percentage per employee for actual time against the subtotal?

Hi NetSuiters,

I am trying to build a report that displays for each employee the time spent per Business Units (class). I have currently build the following report which gives the actual time in absolute value and the total actual time per employee.

For the next step, I would like to have and additional column with the actual time in percentage relative to the subtotals ( = total for one employee). So the idea would be to get the following:

employee X:

BU1 100 hours 67%

BU2 50 hours 33%

Total employee X 150 100%

employee Y:

BU1 150 hours 75%

BU2 50 hours 25%

Total employee Y 200 100%

Currently, I have only been able to get the percentage based on the total hours worked by all employees which is not the objective.