Applying Data Functions to Results

In the Results section, you can only use a data function for totals and subtotals. The other values cannot be recalculated without redoing the query. 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. The following table lists the data functions that you can use with break totals and grand totals.

Table 27. 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	Allows you to create a custom function using JavaScript.