Adding Totals

By default tables show the total of any column placed in the Table Facts area of the data layout. However, sometimes you want the total to be in different places in the report: in a group header, group footer, or somewhere else in the body. You can do this by dragging a column from the section catalog and dropping it directly into the desired report section. Any column that you drag directly into the report is aggregated using the sum function based on the current break level. Note that you do not need to have the column exist in a table; you can drag any column in your results directly into the report.

Frequently, you may want to display different types of the same underlying values displayed side by side such as the average, maximum, or count values from the original data as shown below. In this case, data functions are particularly useful. By dragging the same column from the section catalog next to the original column and applying a data function, different aspects of the original data are revealed.