Total Summary

The Grid View control supports both total and group summaries.

A total summary represents the value of an aggregate function calculated over all rows within the grid and is displayed within the grid footer, provided that the Settings.ShowFooter option is enabled. The Grid View stores its total summary items in the TotalSummary collection.

Company NameUnit PriceQuantityTotal
Vins et alcools Chevalier$14.0012$168.00
Vins et alcools Chevalier$10.0010$100.00
Vins et alcools Chevalier$35.005$175.00
Toms Spezialitäten$19.009$171.00
Toms Spezialitäten$42.0040$1,680.00
Hanari Carnes$8.0010$80.00
Hanari Carnes$42.0035$1,470.00
Hanari Carnes$17.0015$255.00
Victuailles en stock$17.006$102.00
Victuailles en stock$16.0015$240.00
<dx:BootstrapGridView runat="server" DataSourceID="CompaniesOrdersDataSource" KeyFieldName="OrderID">
    <Settings ShowFooter="True" />
    <Columns>
        <dx:BootstrapGridViewDataColumn FieldName="CompanyName" />
        <dx:BootstrapGridViewTextColumn FieldName="UnitPrice">
            <PropertiesTextEdit DisplayFormatString="c" />
        </dx:BootstrapGridViewTextColumn>
        <dx:BootstrapGridViewDataColumn FieldName="Quantity" />
        <dx:BootstrapGridViewTextColumn FieldName="Total" UnboundType="Decimal" UnboundExpression="UnitPrice * Quantity">
            <PropertiesTextEdit DisplayFormatString="c" />
        </dx:BootstrapGridViewTextColumn>
    </Columns>
    <TotalSummary>
        <dx:ASPxSummaryItem FieldName="CompanyName" SummaryType="Count" />
        <dx:ASPxSummaryItem FieldName="Total" SummaryType="Sum" />
    </TotalSummary>
</dx:BootstrapGridView>

Group Summary

The Grid View control supports both total and group summaries.

A group summary represents the summary value calculated within a single group and is displayed in the group row or group footer. Group summaries are stored in the GroupSummary collection.

Company NameRegionUnit PriceQuantityTotal
Country: Argentina (Sum=$8,158.00, Count=34)
Country: Austria (Sum=$139,924.00, Count=125)
 City: Graz (Sum=$113,561.00, Count=102)
 City: Salzburg (Sum=$26,363.00, Count=23)
Country: Belgium (Sum=$35,122.00, Count=56)
Country: Brazil (Sum=$115,121.00, Count=203)
Country: Canada (Sum=$55,358.00, Count=75)
Country: Denmark (Sum=$34,800.00, Count=46)
Country: Finland (Sum=$19,780.00, Count=54)
Country: France (Sum=$85,624.00, Count=184)
<dx:BootstrapGridView runat="server" DataSourceID="CompaniesOrdersDataSource" KeyFieldName="OrderID">
    <Settings ShowGroupPanel="True" />
    <Columns>
        <dx:BootstrapGridViewDataColumn FieldName="Country" GroupIndex="0" />
        <dx:BootstrapGridViewDataColumn FieldName="City" GroupIndex="1" />
        <dx:BootstrapGridViewDataColumn FieldName="CompanyName" />
        ...
    </Columns>
    <GroupSummary>
        <dx:ASPxSummaryItem FieldName="Total" SummaryType="Sum" />
        <dx:ASPxSummaryItem FieldName="CompanyName" SummaryType="Count" />
    </GroupSummary>
</dx:BootstrapGridView>
Screen Size
Color Themes
Demo QR Code