Paging: Group Aggregate For All Data Rows

[G.]

I have a RadGrid configured with Paging and Grouping with Aggregates
- AllowPaging = true
- ShowGroupFooter = true
- RetainGroupFootersVisibility=true

 

 

 

 

<telerik:GridGroupByExpression>
    <GroupByFields>
        <telerik:GridGroupByField FieldName="A" SortOrder="Ascending" HeaderText="A" />
    </GroupByFields>
</telerik:GridGroupByExpression>

I have 1 column defined as Aggregate

 

<telerik:GridBoundColumn AllowFiltering="False" SortExpression="Amount"
    DataField="Amount"  DataFormatString="{0:C2}" Groupable="False" HeaderText="Amount"
    ReadOnly="True" Reorderable="False" Resizable="False" UniqueName="Amount"
    Aggregate="Sum">
</telerik:GridBoundColumn>

Problem

The RadGrid, by default, appears to Aggregate for items in the current page (i.e. The Grouping Total that appears in the GroupFooter... only applies to visible items on the currently selected page (even when the group extends into other pages).

Question

How can I implement a custom aggregate in which I sum all of the values for a particular column within a group (across all data items that are in the group / i.e. across all pages)? 

[Preston]

I am having the same problem.  Please let me know if you find a solution.  

Thank you.