How to Create Report Totals and Subtotals › Creating Groups and Specifying Subtotals

Creating Groups and Specifying Subtotals

In this step, you find the average salary of each department by specifying DEPT-ID as a group field and applying a calculation to that group. To do this:

1. Sort the rows of your report by department. You just did this in the last step of this example.
2. Group the employees according to which department they work in.
3. Calculate the average salary amount for that group.