Skip to main content

Grouping Rows

Grouping Rows​

Now that you have added all the information you need in your report, you can group rows to make the information easier to view. In our salary report example, you could use groups to view employee salaries in each country.

There are two ways to group rows. The easiest way is to click the down arrow ▼ in the header row of the field you want to group and then select Group Rows by This Field. Alternatively, you can use the Add Group search bar in the left-side menu to search for the field you want to group.

In our example, we have grouped the rows by Employee Country. This moves the Employee Country field to the left of the table, shows the number of records per country, and calculates the subtotal salary in the in Amount column.

After grouping your rows, you will see additional options at the bottom of the screen.

  • Row Counts: Displays the number of rows/records per group
  • Detail Rows: Displays each individual row. Deactivating this option will hide the individual rows, showing you only the subtotals of columns containing numerical values and Record Count.
  • Subtotals: Adds the subtotal of numerical records to each group.
  • Grand Total: Adds the grand total of numerical records to the bottom of the table.

For this example, we will deactivate the Row Counts option.

In columns that contain numerical values, such as the Amount column, you can choose what appears in the Subtotal and Grand Total rows. By default, a sum is shown. To change this, click the down arrow ▼ in the header column and select Summarize. You will see five options: Sum, Average, Max, Min, and Median. In our example, we will select Average to show the average salary amount per country.