Include grand totals—ICRW

Some reports might require grand totals. Interactive Custom Report Writer (ICRW) allows you to add totals to columns in both tables and pivot tables. Totals can appear at the beginning or at the end of the data.

Add grand totals after the values

Including grand totals at the end of a set of data is the most common way to format a report.

Add grand totals in a table

1. Open an ICRW report and go to the Refine tab.
2. Move to the Table view.
3. Right-click a column title and select Show row level Grand Total > After values.

Add grand totals in a pivot table

1. Open the report and go to the Refine tab.
2. Move to the Pivot table view.
3. Right-click a column title and select Show row level grand total > After values.

Add grand totals before the values

This task is available for use with pivot tables.

Add grand totals in a pivot table

1. Open the report and go to the Refine tab.
2. Move to the Pivot table view.
3. In the Rows section, select (Sum/Totals).
4. Select Before.