When group by fields are selected on page 3 of the Grid Wizard, the grid will display with header rows indicating that the records below the header have the same value for the grouped field. See the Group by field section of the Grid Wizard for more information on configuring group by fields.
The following field types are available for grouping:
If you have enabled the "SUM" field property, summaries will appear for each grouping header. These summaries are for the entire dataset of the grid, not just the current page. For example, if your grid has 1,000 records and the current page shows the first 100 records, the summaries will be calculated based on all 1,000 records.
The grand total summaries are shown in the light yellow row at the top of the grid. Subtotal summaries are shown in shades of blue.
In multi-currency orgs, summaries for currency fields are displayed in the org’s corporate currency, unless all records on the current page of the grid have the same currency. In this case, the summaries will be displayed in the currency of the records on the grid.
Use the checkboxes in each group by header to check or uncheck the data rows within a grouping.
Click on group by headers to expand or collapse the headers and data rows within that grouping.
Use the Groupings menu to expand or collapse groupings on the grid. See the Groupings menu section for more information.
Grid of Opportunities grouped by Account Name and Stage. Summaries are shown for Amount (SUM) and Probability (AVG).