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:
Switch the page to the edit mode.
Select the macro and click Edit.
Switch to the Calculations tab.
Select the Total column field and choose the required operation type.
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.
Save the macro and the page.
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:
Switch the page to the edit mode.
Select the macro and click Edit.
Switch to the Calculations tab.
Click Set total row.
Select the operation type for specific columns.
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".
Save the macro and the page.
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.
Switch the page to the edit mode.
Select the macro and click Edit.
Switch to the Table View tab.
Locate the Sparkline charts slider and tick it.
Specify the appropriate name for the column outputting sparkline charts.
Click Save.
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:
