54
Exercise - Group and Subtotal by Category
In this exercise, you will group data by category and show subtotals for each category. Note that the
products in your worksheet must have information assigned in the Category column.
Before you start this exercise, create a user report based
on the Standard report called List Price
Report.
1. Click on the Report toolbar.
2. On the Grouping and Subtotals dialog, click Add under Groups.
3. Under Group Details, check Category.
4. Under Group Header, check Show to insert a Group Header section in the report
design.
5. Under Group Footer, check Show to insert a Group Footer section in the report
design.
6. Click OK.
Now you will add the fields you want to display in the Group Header and Group
Footer sections.
7. From the Field Explorer tab expand the + sign beside Group 1 Header.
8. Drag the field Category to the Group 1 Header section.
9. Double-click on the field to display its properties. Change the style to Bold then click
OK.
10. Double-click on the section to change its properties. Under Borders, check Bottom
border then click OK.
11. Resize the section from the bottom to remove the empty space.
The Group Header
section should look like this: