Grand Total and Sub Total

Grand Total

In report tables, the Grand Total for a field will provide either the sum (average, maximum, minimun) of all values or count (count distinct) values within that field across the entire data source.

For example, in a report for Northwind database’s Orders table, the Grand Total for Freight field will tell the sum of all Freight costs until now.

Fig. 291 Grand Total Freight field.

Fig. 292 Grand Total setting for Freight field.

List of Grand Total Functions

Function	Description
Expression	User can combine the expression to collect data by using functions, operators and field names.
Average	Return the avarage of all values within the field that set grand total across the entire data source.
Count	Return the quantity of all values within the field that set grand total across the entire data source.
Count Distinct	Return the count unique number of all values within the field that set grand total across the entire data source.
Maximun	Return the maximun value of the field that set grand total across the entire data source.
Minimun	Return the minimum value of the field that set grand total across the entire data source.
Sum	Return the sum of all values within the field that set grand total across the entire data source.
Count Distinct	Return the sum unique number of all values within the field that set grand total across the entire data source.

Sub Total

In report tables, the Sub Total for a field will provide either the sum (average, maximum, minimun) of all values or count (count distinct) values within that field for each seperated group without having any sub-report.

For example, in a report for Northwind database’s Orders table, to have the sum for all Freight costs to each country without having to create additional reports, Sub Total can be used.

Fig. 293 Sub Total Freight field seperated by ShipCountry.

Fig. 294 Sub Total setting for Freight field.

List of Sub Total Functions

Function	Description
Expression	User can combine the expression to collect data for each group by using functions, operators and field names.
Average	Return the avarage of all values within the field that set Sub Total across the entire group.
Count	Return the quantity of all values within the field that set Sub Total across the entire group.
Count Distinct	Return the count unique number of all values within the field that set Sub Total across the entire group.
Maximun	Return the maximun value of the field that set Sub Total across the entire group.
Minimun	Return the minimum value of the field that set Sub Total across the entire group.
Sum	Return the sum of all values within the field that set Sub Total across the entire group.
Sum Distinct	Return the sum unique number of all values within the field that set Sub Total across the entire group.