The following properties have been set for the columns in the Dataset (using Microsoft's famous Northwind dummy data dataset)
3 columns have row grouping applied on them: Ship Country (on by default), Employee and Ship Via
3 columns have aggregation applied and so can be used in pivoting: Freight, Order Cost and Item Count
3 sets of column groups have been created (this is where columns are 'banded' together and cannot be separated from each other): Customer Info, Order, andShipping Details
3 columns have sum aggregation set so that you can see their sum totals when the grouped row collapsed from each other): Order Cost, Package Cost, and Item Count
All the many Adaptable Blotter functions continue to work the same regardless of whether the grid is in normal, grouped or pivoting mode.