You can add various functions to the table footer. These functions summarize the data of the entire table.
Select the column that you want to summarize, then click .
The Column Properties dialog opens.
In the Column Properties dialog, select the Summary Calculations page.
Select the functions that you want to use in the table footer. Each function will appear in a separate row.
Adjust the number format for each function used.
| Show details of taskShow details of task |
Under Number Format for Summary Calculations, select the relevant function.
Adjust the number format as required.
The Preview area shows the appearance of the currently selected settings.
Save the settings.
The selected functions are added to the table as footer rows. Each function is shown in its own footer row.
If you add a summary calculation, the table will expand downwards in the generated template. However, the layout of the report item is not automatically adjusted in the Editing Pane! You need to resize the table layout to allow for the additional footer lines. Otherwise, the subsequent report items may overlay the table footer in the generated template. |
If a table column shows an expression that contains a calculation variable or a report parameter, you cannot add a summary calculation for this column. |