Applying Data Functions to Tables

In the Tables section, a Dashboard can be used only for totals and subtotals. Data functions return to the underlying values and recalculate the value according to the type of function specified.

You can apply a break (subtotal), grand, or custom total to any column. A grand total on a numeric column applies a default sum function. However, each column can have a number of grand totals, each with a different aggregate function applied to it. The table below lists the data functions that you can use with break totals and grand totals.

Table 34. Break Total and Grand Total Data Functions

Function	Description
Sum	Returns sum of underlying values.
Average	Returns average of underlying values.
Minimum	Returns lowest of underlying values.
Maximum	Returns highest of underlying values.
Count	Returns number of underlying values.
Other	Enables you to create a custom function using JavaScript.