Changes

5. Close the '''report''' and display the '''Report Builder'''.

You use the '''Group By''' row to specify the type of totaling that you require for each column.

* '''Average''' - The average of a numeric field.

1. Set the following '''Totals''' options:

[[Image:Reps65.png]]

You can also apply sorting options to the report.

[[Image:Reps67.png]]

Next you will copy the existing report and display the total salary for each department.

[[Image:Reps69.png]]

The '''average''' function will calculate the '''average''' for each group.