Use the Group By feature to organize records into logical groups based on shared values. Grouping makes large datasets easier to navigate and analyze. You can expand or collapse individual groups to control the level of detail displayed in the table.
To group rows:
From the PowerTable tab, select Group By.
From the dropdown, select the column to group the records, and then select Save.
PowerTable groups the records based on the selected column. The following example shows records grouped by the ProductSubcategoryKey column. The numerical fields are aggregated as a sum.
Select the expand or collapse arrow beside a group name to show or hide the records within that group.
You can create subgroups within a group.
Select Group By again, then select Add Sub Group.
Select another column from the dropdown, and then select Save.
PowerTable creates nested groups within the existing group. The following example shows the records further grouped by the ModelName column under ProductSubcategoryKey.
To remove a group, select the delete (bin) icon next to it, and then select Save. To return to the default table view, remove all groups.
You can continue to perform table operations on grouped records, including:
