In the Table containing the Employee id, Year, and Hours worked, create a new Summary field which I'll call "Avg_Hours". In the Options, set this to be an Average of the Hours Field.
Next, Create a new layout, which i'll call 'Work History Report'. Choose "Columnar List/Report".
Select "Report with Grouped Data".
Select the Field you want to be displayed on the report, such as Employee_id, Year, Hours and the newly created Avg_Hours summary field.
In the Organize Records by Category Options, set the report to be organized/grouped by your Employee_id Field first, then by Year. The next window will allow you to select how you want your report to be sorted.
Proceed through the next windows and set any options you wish and select to view your report in Layout in Mode.
Once in Layout Mode and viewing the 'Work History Report' layout, at the top of your menu, clickon Layout > Part Setup. Click on CREATE , Subsumarry when sorted by "Employee_id".
You will then be given the option to print the newly created Subsummary part above or below. Select Below.
Drag the 'Avg_Hours' Submarry field we created into the Subsummary part in your layout.
So see the report, in Browse mode, Sort the records by Employee ID and by Year.
Then Enter Preview Mode.
**Please note, i'm not using FM11, so some options might slightly vary.
If you'd like to explore the possibilities of summary reports a bit further, here's a link to a simple tutorial on setting up summary reports that you may find useful:
Creating Filemaker Pro summary reports--Tutorial