Grouping and aggregation fields

Grouping and aggregation options can be applied to query result columns to organize the result data into logical or summarized groupings.

No aggregation
Select this option to remove any aggregation or summary formatting from the selected column.
Top Group
Select this option to group data across the top of the query results by the selected column. Placing a column in a top group will display related values of that column on the horizontal axis, which is known as pivot or ACROSS functionality. You can define multiple columns of top groups. You can specify that Top Groups include summary information. With the column selected, click Show Total Summaries from the pop-up menu. The query results will be reformatted so that the column spans the other columns in the result set. A summary line for each row in the query results is added.
Side Group
Select this option to group data down the left side of the query results by the selected column.
Count
Select this option to create a summary row at the bottom of the query results showing the number of values in the column.
First
Select this option to create a summary row at the bottom of the query results showing the first value in the column.
Last
Select this option to create a summary row at the bottom of the query results showing the last value in the column.
Maximum
Select this option to create a summary row at the bottom of the query results showing the maximum value in the column.
Minimum
Select this option to create a summary row at the bottom of the query results showing the minimum value in the column.
Sum
Select this option to create a summary row in the query results showing the sum of the values in the column. This option calculates interim summaries and overall summaries if another column is selected for grouping with summaries.
Cumulative sum
Select this option to display the values in the column as a cumulative sum, which is a rolling sum. Each value is added to the value in the row below it and the sum of the two values becomes the value that is added. A cumulative summary is presented at the end.
Average
Select this option to create a summary row showing the average of the values in the column.
Standard Deviation
Select this option to create a summary row showing the standard deviation of the values in the column. The standard deviation is a statistic that tells you how tightly all the various examples are clustered around the mean in a set of data.
Percentage of group
Select this option to display the values in the column as a percentage of the group's total, with a summary row showing the sum of the percentages. Percentage of group identifies how each value in the group contributes to the whole. For example a salary of $1,000 is 10% of a total salary of $10,000.
Percentage of total
Select this option to display the values in the column as a percentage of the column total, with a summary row showing the sum of the percentages.
Cumulative percentage of group
Select this option to display the values in the column as a percentage of the group total. A summary row at the bottom of the query results shows the sum of the percentages. For example, DEPT 42 earns 0.42% in commissions.
Cumulative percentage of total
Select this option to display the values in the column as a percentage value of the group total and a percentage value of the column total. A summary row at the bottom of the query results shows the sum of the percentages. For example, within DEPT 42, Wheeler earns 44.60% of the commissions, while Williams earns 55.40%, and Smith earns no commission. Overall, this DEPT 42 earns 5.75% in commissions for the company.