Calculations

Various mathematical and arithmetic calculations can be executed with row or column values. Tap the row or column header and select the Calculate item in the dialog box that opens. The following dialog box opens:

Select the calculation method in the list to calculate for the selected row or column. To set calculation parameters, use the button next to the calculation method name.

After calculation a row or column with corresponding header containing changed data is created next to the selected row or column. The icon appears next to the selected row or column. Click the icon to hide calculated rows or columns.

Example

The example of a table with calculation configured for one column (2007):

See also:

Table | Setting Up Columns and Rows