Calculate Totals in GridPanel

[simonmicheal]

I would like to calculate the totals of this column using the ext:GridPanel

<ext:RecordField Name="TotalAmountDue" Type="Float" />

<ext:Store ID="StoreVendor" OnSubmitData="StoreVendor_Submit" AutoDataBind="false"
        runat="server">
        <AjaxEventConfig IsUpload="true" />
        <Reader>
            <ext:JsonReader ReaderID="InvolvedPartyID">
                <Fields>
                    <ext:RecordField Name="InvolvedPartyID" />
                    <ext:RecordField Name="CompanyName" />
                    <ext:RecordField Name="TotalLineCount" />
                    <ext:RecordField Name="TotalAmountDue" Type="Float" />
                </Fields>
            </ext:JsonReader>
        </Reader>
        <Listeners>
            <LoadException Handler="Ext.MessageBox.alert('Load failed', response.statusText);" />
        </Listeners>
        <AjaxEventConfig Timeout="900000" />
    </ext:Store>

i tried grouping but never seemed to work

<ColumnModel ID="ColumnModel2" runat="server">
                        <Columns>
                            <ext:Column Header="Company Name" ColumnID="CompanyName" Width="150" DataIndex="CompanyName" />
                            <ext:Column Header="Total Line Count (STAT)" Width="150" DataIndex="TotalLineCount" />
                            <ext:GroupingSummaryColumn Groupable=true  Header="Total Amount Due" ColumnID="TotalAmountDue" DataIndex="TotalAmountDue"
                                Sortable="true" SummaryType="Sum" >
                                <Renderer Format="UsMoney" />
                                <SummaryRenderer Format="UsMoney" />
                            </ext:GroupingSummaryColumn>
                            <ext:Column ColumnID="Details" Header="Details" Width="50" Align="Center" Fixed="true"
                                MenuDisabled="true" Resizable="false">
                                <Renderer Fn="addImage" />
                            </ext:Column>
                        </Columns>
                    </ColumnModel>
                    <View>
                        <ext:GroupingView  ID="GroupingView1" EnableRowBody=true Enabled=true runat="server" AutoFill="true" ShowGroupName="true"
                            EnableNoGroups="false" HideGroupedColumn="false" />
                    </View>
                    <Plugins>
                        <ext:GroupingSummary Enabled=true ID="GroupingSummary1" runat="server" />
                        <ext:GridFilters runat="server" ID="GridFilters1" Local="true">
                            <Filters>
                                <ext:StringFilter DataIndex="CompanyName" />
                                <ext:StringFilter DataIndex="TotalLineCount" />
                                <ext:StringFilter DataIndex="TotalAmountDue" />
                            </Filters>
                        </ext:GridFilters>
                    </Plugins>

Thanks

[Vladimir]

Hi,

Please see the following example which shows how to use GroupingSummary


https://examples1.ext.net/#/GridPane...oupingSummary/