Using functions

Top  Previous  Next

In our example we see the sum of each employee’s salary over four years in the “Total” line. Any of the following aggregate functions can be used:


SUM – sum of values

MIN – minimal value

MAX – maximal value

AVG – average value

COUNT – number of values


Let’s use the “MIN” function in our example. Open the cross-tab editor and in list 5 (the “Salary” field item) click the down arrow.




Select the “MIN” function from the drop-down list. Now we can change the text in the total cells from “Total” to “Minimum.” The finished report looks like this: