calculating sum of max of hours

[Anonymous]

Hello All, 

What I have to do in this problem is - 

I have just used sample of my data but i have more than 1000 employees and I have more than 1 period in my data I just took example of single period and period is YYYYWW (WW-weeknumber of year)

As you can see for a given employee and in a given period, all values of contractual hours are same and value of total hours is different.

So what I need is I want to sum the max of contractual hours for each period for each employee.

For Example if i talk about an employee x then total hours for that employee is Sum(Total hours) and contractual hours is Max(contractual hours) for a given period but what i want is if I am not considering period then contractual hours will be sum of max of contractual hours for each period

Thanks in advance

[sturlaws]

Hi @Anonymous,

could you provide a sample dataset(not a screenshot), as well as an example using that dataset on what is the desired output?

Cheers,
Sturla