Skip to main content

Grand Total and Sub Total

  • Updated
 

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
../_images/Grand_Total_Setting_For_Freight.png

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
../_images/Sub_Total_Freight_Setting.png

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.

 

 

Related articles