Is there a way to show the group totals, but have them reflect the entire group, not just the part of the group that is currently being displayed on the current grid page?  For example, the grid is set to 30 records per page. If say records 27-30 on page 1 are of a group that has a total of 10 records so that the remainging records are on the next page. The total at the bottom of page 1 does not include the remaining records on page 2. Is there a way to get the group total to reflect the records on the other page?  If not, is there a way to hide the last group footer from the page if records go onto the next page?  I have tried using the following settings including the CalculateAllData to no avail. Any suggestions?  It's very confusing for users.

        <ISWebGrid:WebGrid ID="WebGrid1" Height="550px" runat="server" UseDefaultStyle="True" DataSourceID="ObjectDataSource1"
             DefaultStyleMode="Elegant">
      <LayoutSettings PagingExportMode="ExportAllData" AllowExport="Yes" Hierarchical="true" AllowColumnMove="Yes"
          HierarchicalMode="Preload" HideColumnsWhenGrouped="Yes" AllowContextMenu="true"
          ColumnFooters="Default" PagingMode="ClassicPaging" AutoHeight="true" AutoWidth="true" StatusBarVisible="true"
          InProgressUIBehavior="ChangeCursorToHourGlass" PagingDetectPartialGroupRows="true"
          ColumnFooterAggregateMode="CalculateAllData" GridLines="None" TreeLines="false"
          ColumnSetHeaders="Yes" GroupByBoxVisible="false">
         
      </LayoutSettings>  

<ISWebGrid:WebGridColumn Caption="Market Value" IsAutoWidth="true" DataMember="mMarketValue"