Summary or Group-by queries

Summary queries (also called Group-By queries) are used to summarise the contents of a table.

You mark a query as a Summary Query by selecting the Summary Query option.

query_builder_summ

Suppose you wish to summarize your sales by Region and Sales Person

Region and Sales Person are the columns you are Summarizing By. You mark these in the grid by clicking on the Group By column
Sales is the column you are Summarizing. This is generally a numeric column.
You need to provide a summary / aggregate function for this column - this specifies the statistic you will be computing - Sum, Average, Minimum, Maximum etc.

There can be multiple

Advanced Query Tool