Dynamic Weighted Average

Hi,

A table contains three columns:

• Employee names - multiple rows for each name
• Dates - multiple rows for each name, isn't same periods for each employee
• QTY of hours

Is there a way to calculate average hours worked per employee per week (one number)?

For example , the data is filtered to display 4 weeks period, so the total hours should be dived by emp. qty and week qty, which isn't equal to 4 for all employees.

Thanks,