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.
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.
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. |