Help Index

Translations of this page:
 
 

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

  1. 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.
  2. Move your mouse over Subtotal to reveal the submenu.
  3. 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:

NameDescriptionExample result
SUMThe sum of the values in the column16
AVGThe average (mean) value3.2
MINThe minimum (lowest) value0
MEDThe median value6
MAXThe maximum (highest) value3

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.

 
subtotals_for_a_column.txt · Last modified: 2008/08/12 10:43 by luke_smallthought.com