Summarizing Data in a Table
When you aggregate data in a table, you can compute summaries on a group-by-group basis and/or on a global basis (e.g., grand total).
To create a summary based on a particular grouping level, follow the steps below:
For a categorical field, select 'Default'. For a Date field, select a Date level such as 'Year' or 'Month'.
1. Right-click on the detail cell that you want to summarize.
2. From the context menu, select 'Cell' > 'Summarize', and choose the desired aggregation method (e.g., 'Average', 'Max', etc.)

This defines the field as a summary field. Because the field resides in the detail row, it only summarizes a single detail value. To summarize a particular group, or the entire table, proceed to the next steps.
To add a grouping region, see Displaying the Grouping Field in a Group Region.
3. To summarize a particular group, Ctrl-drag (or copy and paste) the summary field to the corresponding grouping header or footer region.

This adds the selected field to the summary area of the Binding panel.
4. To summarize all records in the table, follow the steps below:
a. Right-click on any cell in the table, and select 'Region' > 'Insert Table Footer' from the context menu. This adds the table footer region.

b. Ctrl-drag (or copy and paste) the summary field to the table footer region.

This adds the selected field to the summary area of the Binding panel.
See Modifying Summary Properties to make further adjustments to the summarization process.
| << Setting Global Grouping Options | © 1996-2013 InetSoft Technology Corporation (v11.4) | Modifying Summary Properties >> |