Group/Sum/Sort - Summary
Trouble viewing images? Click on images to enlarge.
Adding summaries to your View will allow you to perform calculations on your selected group options. Please note that summaries should only be added to numeric fields and not strings. The example below is grouped by EmployeeID.
To add a summary, select the desired report field in the summary drop-down list. To add additional summaries, click the green + symbol located in the Add/Remove column. In the example below we are requesting a total Record Count for EmployeeID and a summation of the Freight.
The data will be summarized in the order the summary options are placed in the list box. To remove a summary, click the red X located in the Add/Remove column on the appropriate value.
Results of Summary
AVG Computes an average of the selected report field
COUNT Counts the total number of records
MAX Computes the maximum for the select report field
MIN Computes the minimum for the select report field
SUM Computes a summation of the selected report field
VALUE Returns the first value
Please sign in to leave a comment.