Grouping
Add Grouping
The column titles of your product table can be understood as attributes of your products. By pulling column titles from the product table into the grouping field, you can group your table based on these attributes for a better overview of the product line. This function is especially useful in tables with a large number of products.
1) There are two options for sorting your table by its attributes.
Option A:
Click and hold the column title by which you wish to group your column. Drag the selected field into the grouping field and release the mouse button.
Option B:
Right-click the column title by which you with to group your column and select the menu option Group by this Column.
2) The table is now grouped by the selected attribute.
3) There are two options to show or collapse your groupings.
Option A: To show only one grouping, click on the small arrow to the left of the grouping. This allows you to show or collapse the grouping.
Option B: To open or collapse all groupings at once, right-click on the attribute and select Show All or Collapse All.
4) All products corresponding to the expression of the selected attribute will be displayed.
5) You may choose to further sub-group products below the original grouping. As described in Step 1, click and drag your desired column title into the grouping field.
Undo Grouping
1) There are two options to undo the groupings in your table.
Option A:
Right-click on the attribute in the grouping field and select Undo Grouping from the menu.
Option B:
Right-click in the column title of the product table and select Undo Grouping from the menu.
2) The grouping by the chosen attribute has now been removed from the table.
Hiding the Grouping Field
Right-click in the grouping field or in a column title and select Grouping Field from the menu.
Show Grouping Field
Right-click in a column title and select Grouping Field from the menu.
