Shridhar,
there is a nice sample :
xbgrpsum.prg@ 10,10 XBROWSE oBrw SIZE -10,-10 PIXEL OF oDlg ;
AUTOCOLS ;
HEADERS 'Product',
'USA', 'Canada',
'UK', 'Spain' ;
ARRAY aData CELL LINES NOBORDER FASTEDIT FOOTERS
AEval( oBrw:aCols, { |o| o:nEditType := EDIT_GET } )
WITH OBJECT oBrw
// Make Groups
:SetGroupHeader( 'Americas', 2, 3, oBold )
:SetGroupHeader( 'Europe', 4, 5, oBold ):lAllowColReGroup := .t. // columns can be moved accross groups
// Group totals
:SetGroupTotal( 'Americas', 'Total' )
:SetGroupTotal( 'Europe', 'Total' )
// Grand Total
:SetGroupTotal( { 'Americas_Total', 'Europe_Total' }, 'Grand' + CRLF + 'Total', AGGR_SUM, oBold )
END
Best Regards
Uwe