The following properties have been set for the columns in the Dataset (using Microsoft's famous Northwind dummy data dataset)
3 columns haverow grouping applied on them:Ship Country (on by default),Employee andShip Via
3 columns haveaggregation applied and so can be used in pivoting:Freight,Order Cost andItem Count
3 sets ofcolumn 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 havesum aggregation set so that you can see their sum totals when the grouped row collapsed from each other):Order Cost,Package Cost, andItem Count
All the many Adaptable Blotter functions continue to work the same regardless of whether the grid is in normal, grouped or pivoting mode.