In this article:

Displaying Totals

Setting Up Totals

Formatting of Data and Totals Headers

Hiding Totals

Calculating Totals

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.

Displaying Totals

To display totals by rows or by columns:

NOTE. In the Dashboards tool select the Table > Add Subtotal/Table > Add Total item in the context menu.

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.

Available calculation methods

Set custom names of totals

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.

Setting Up Totals

To set up totals, use the Calculation Options, the Totals and the Output String side panel tabs.

Totals Calculation Options

To set up totals calculation options, use the Calculation Options or the Totals tabs on the side panel.

To display the tab

Determine the following calculation options on the tab:

Treat empty values as zeros

Ignore values in nodes

Grand total/subtotal

Output before data

Calculate total for one element

Output String

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 display the tab

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.

Type of output total

Element name

Delimiter

Examples of applying total display setting in the parent element string

Formatting of Data and Totals Headers

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.

To display the tab

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.

Hiding Totals

Select the Reset item in the drop-down menu of the Row Totals / Column Totals button on the ribbon tabs:

See also:

Working with Data Table