tableSummaryRows property
The collection of GridTableSummaryRow.
This enables you to show the total or summary for columns i.e Max, Min, Average, and Count for the whole DataGrid.
Load the required widget in summary cell by overriding and returning the widget in DataGridSource.buildTableSummaryCellWidget method.
The following example shows how to display the table summary rows at the top and bottom with different options.
@override
Widget build(BuildContext context) {
return Scaffold(
appBar: AppBar(
title: const Text('Syncfusion Flutter DataGrid'),
),
body: SfDataGrid(
source: employeeDataSource,
tableSummaryRows: [
GridTableSummaryRow(
showSummaryInRow: true,
title: 'Total Employee Count: {Count}',
columns: [
GridSummaryColumn(
name: 'Count',
columnName: 'name',
summaryType: GridSummaryType.count)
],
position: GridTableSummaryRowPosition.top),
GridTableSummaryRow(
showSummaryInRow: false,
columns: [
GridSummaryColumn(
name: 'Sum',
columnName: 'salary',
summaryType: GridSummaryType.sum)
],
position: GridTableSummaryRowPosition.bottom)
],
columns: <GridColumn>[
GridColumn(
columnName: 'id',
label: Container(
padding: EdgeInsets.all(16.0),
alignment: Alignment.center,
child: Text(
'ID',
))),
GridColumn(
columnName: 'name',
label: Container(
padding: EdgeInsets.all(8.0),
alignment: Alignment.center,
child: Text('Name'))),
GridColumn(
columnName: 'designation',
label: Container(
padding: EdgeInsets.all(8.0),
alignment: Alignment.center,
child: Text(
'Designation',
overflow: TextOverflow.ellipsis,
))),
GridColumn(
columnName: 'salary',
label: Container(
padding: EdgeInsets.all(8.0),
alignment: Alignment.center,
child: Text('Salary'))),
],
),
);
}
class EmployeeDataSource extends DataGridSource {
@override
Widget? buildTableSummaryCellWidget(
GridTableSummaryRow summaryRow,
GridSummaryColumn? summaryColumn,
RowColumnIndex rowColumnIndex,
String summaryValue) {
return Container(
padding: EdgeInsets.all(16.0),
alignment: Alignment.centerLeft,
child: Text(summaryValue));
}
Implementation
final List<GridTableSummaryRow> tableSummaryRows;