Any way to get the sum of hours based on the employee name?

[RR21 (Raphael Razote)]

Hi!

We’re trying to move away from complex automations involving getting an employee’s workload (in hours). Is there a way to do this?

Context:

We have 4 columns in a pulse item (pulse item = client/account) where we assign people there. These are:

1. AM 1
2. AM 2
3. Support 1
4. Support 2

We then have corresponding columns for estimated work hours based on the above:

1. AM 1 Hours
2. AM 2 Hours
3. Support 1 Hours
4. Support 2 Hours

What we want is that if a person is assigned as AM 1, then the total of those items assigned to him/her as AM 1 will be shown in a summary table on another board (example of the summary table below):

This will also be applicable if the same person is assigned to other accounts as AM 2, Support 1, Support 2, etc.

Any suggestions will be appreciated!