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.

Example of Summary Query

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