Grouping or summarizing rows

In QuickTable, you can group values in various rows into a single value by grouping the rows according to the values in one or more columns. You can choose from two types of grouping operations:

• Group by as new table

• Group by as new column(s)

For this tutorial, you'll be using the following sample table.

Where to find the Group by button

You can easily find the Group by operation in the toolbar.

Use an aggregate function to group by one or more columns

In this example, your goal is to aggregate sales by country and salesperson. You will use the Country and Salesperson columns to perform the grouping operation.

Select Country, Salesperson in Group by.

Select Sales, click "+Add value", and select Profit:

Click Preview button, this operation gives you the following table:

Operations available

With the Group by feature, the available operations can be categorized in two ways:

• Row level operation

• Column level operation

The following table describes each of these operations.

Operation Name	Category	Description
Sum	Column operation	Sums up all values from a column
Average	Column operation	Calculates the average value from a column
Min	Column operation	Calculates the minimum value from a column
Max	Column operation	Calculates the maximum value from a column
Count	Row operation	Calculates the total number of rows from a given group
Distinct Count	Row operation	Calculates the number of distinct rows from a given group

Group by as new table or as new column(s)

If you choose "Group by as new table", the resulting table will overwrite the previous table. And if you choose "Group by as new column(s)", the new columns after aggregate calculation will be generated inside the original table, just like this: