In a Table view with a column containing numbers, Dabble can calculate subtotals. The column must contain Number values, Money values or Duration values, or a numerically derived value such as the number of entries in a list.
Subtotal calculations can include sums and averages, as well as the minimum, maximum and median value.
To activate subtotals, you choose the operation you want — either the sum or the average of the column — and the subtotal will appear at the bottom of the column. The amount shown applies to all of the entries in a view, even if they are not visible on the current page.
If you have groups of entries, you will see a subtotal for each group as well as for the entire view. The group subtotals will then be shown in the Compact view as well allowing you to get an easy summary of numeric data.
Given a column of numbers containing the values 0, 2, 3, 5 and 6, the result would be as follows:
| Name | Description | Example result |
|---|---|---|
| SUM | The sum of the values in the column | 16 |
| AVG | The average (mean) value | 3.2 |
| MIN | The minimum (lowest) value | 0 |
| MED | The median value | 6 |
| MAX | The maximum (highest) value | 3 |
To remove subtotals from a column, click its header to open the menu. Move your mouse over Subtotal to reveal the submenu and click None.