Row Grouping

Feature description

The following examples show some possible results. The grouping is done fully automatic from the table data.

Grouping by a single column

In this table with fictional data, the “Company” column was chosen as a “category”, so that all people belonging to that company are “grouped” under a common sub-heading:

Grouping by multiple columns

It is also possible to designate multiple columns to achieve multiple levels of grouping. In this example, the “Country” column was chosen as a second level:

Further details

Depending on the specific needs, it might make sense to then hide the columns that were used as categories, to reduce the duplication of shown information. For that, you can e.g. add this to the “Custom Commands” text field on the table’s “Edit” screen:

columnDefs: [
  {
    visible: false,
    targets: [ 3 ],
  },
],Code language: JavaScript (javascript)

where 3 is the index of the column that is to be hidden. Important: The index is the column number minus 1, so the 3 in this example would hide the 4th column.