In the pivot grid widget, we can group the data for better analysis by adding one or more rows, columns, or both.
Each row or column value acts as a group with respective aggregated values while grouping. In multiple groups, each row or column value is arranged as a nested level, forming a hierarchy.
Here, I am going to drag and drop one more field, “ShipName,” to the “Row(s)” box, and “ShipRegion” to the “Column(s)” box.
Now, my widget looks like the grid below with grouping.
I would like to expand each node in a row and column, so I am going to enable the “Expand Nodes by Default” option in “Basic Settings” under the “Properties” column.