Need to create average hours per employee per month
Hi - I would like to create a chart with the average overtime per employee by month by work department. The table which has employee and total hours is joined to the calendar table by the work week ending field. I need the calendar table to group by month/year. How can I aggregate the employees by month to give an average? In excel I am doing Total Hours/Distinct Employee. Please let me know if you need more info to answer this question. This is the first time I've submitted anything to this community.
