In this article:
Totals in data table can be set up to be displayed by rows and/or columns.
NOTE. If filter is used in the Interactive Data Entry Forms extension, totals will be hidden.
To display totals by rows or by columns:
Select the Add Subtotal/Add Total item in the context menu of table heading or sidehead and select totals calculation option in the drop-down menu.
NOTE. In the Dashboards tool select the Table > Add Subtotal/Table > Add Total item in the context menu.
Select the required total calculation options in the drop-down menu of the Totals by Rows / Totals by Columns button on the ribbon tab:
Home, Table or Designer in express reports or dashboards.
Designer in regular reports.
Select the table heading or sidehead and select the required total calculation methods on the Totals tab. Tab appearance differs in the desktop application and in the web application:
To enable all selected calculation methods and delete all custom names, click the Clear button.
To display totals by hierarchy or by levels, select the Calculate Hierarchy Totals or Calculate Level Totals checkboxes.
Examples of row and column totals
To set up calculation by edited data without preliminary data saving to the source, use Setting Up Formula Calculation.
To set up totals, use the Calculation Options, the Totals and the Output String side panel tabs.
To set up totals calculation options, use the Calculation Options or the Totals tabs on the side panel.
Determine the following calculation options on the tab:
Calculate total for one element
If the table displays elements of hierarchical dimension of various hierarchy levels, use the Output String side panel tab to display total or hierarchy total in the parent element string.
To set up display parameters of totals in the parent element string, select one or both checkboxes. The setting is separate for row and column totals.
Examples of applying total display setting in the parent element string
Totals data and headers can be formatted on the Data Formatting and Header Formatting tabs in the Totals group of tabs of the side panel.
The following formatting settings are available:
The following settings are available for data formatting:
NOTE. Style formatting setting can be overlapped by settings of other elements.
Select the Reset item in the drop-down menu of the Row Totals / Column Totals button on the ribbon tabs:
Home, Table or Designer in express reports and dashboards.
Designer in regular reports.
See also: