Subtotals for a column
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.
How to activate subtotals
- Click the header of the column you want subtotals for to open its menu. It must be a column containing numeric values (see the first paragraph above) that Dabble recognizes.
- Move your mouse over Subtotal to reveal the submenu.
- Choose the type of subtotal you want.
Types of subtotals
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 |
Removing subtotals
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.
