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.

../_images/GrandTotal_For_Freight_Preview.png

Fig. 291 Grand Total Freight field.

../_images/Grand_Total_Setting_For_Freight.png

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.

../_images/Sub_Total_Freight_Preview.png

Fig. 293 Sub Total Freight field seperated by ShipCountry.

../_images/Sub_Total_Freight_Setting.png

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.