1. Home
  2. help
  3. How to Create a Pivot Grid Widget
  4. Adding One or More Rows and Columns

Adding One or More Rows and Columns

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.

Adding more fields

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.

Enabling expand nodes by default

Was this article helpful to you? Yes No