Read more:

Output the Total column

The app allows you to output the Total column for your table. The following operations are available:

  • Sum
  • Average
  • Multiplication
  • Min
  • Max

To enable the Total column for the table:

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Calculations tab.
  4. Select the Total column field and choose the required operation type.
  5. Once the operation type is selected, the Total column title field becomes visible - you may assign your custom name for the total column.
    The default name corresponds to the chosen operation type.
  6. Save the macro and the page.

Please note that on Data Center in the app versions older than 12.1.2 the Total column field was called Operation type for Total column. Other steps remain the same.

Output the Total row

The app allows you to output the Total row for your table. The following operations are available:

  • Sum
  • Average
  • Multiplication
  • Min
  • Max
  • Count
  • Count not empty

To enable the Total row for the table:

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Calculations tab.
  4. Click Set total row.
  5. Select the operation type for specific columns.
  6. Locate the Total row title field and assign your custom name for the total row if required.
    The default name for the Total row is "Total".
  7. Save the macro and the page.

Please note that on Data Center in the app versions older than 12.1.2 the Set total row option was called Count totals for columns. Other steps remain the same.

Output sparkline charts within tables

The app allows you to embed sparkline charts into the table column. Sparkline charts allow you to quickly visualize your data sets and see the data movements at once.

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Table View tab.
  4. Locate the Sparkline charts slider and tick it.
  5. Specify the appropriate name for the column outputting sparkline charts.
  6. Click Save.
  7. Once you save the page, you will see sparkline charts in a new table column.

If your table contains decimal numbers, you may need to specify the correct decimal separator on the Filtration tab.


Learn how to perform complex calculations and aggregate table data:

Create a pivot table from your table, calculate and aggregate data

Merge multiple tables, perform complex calculations and custom transformations