Instead of defining each aggregation type and group by columns separately, you can call this function and enter the simplified aggregation syntax separated using BY.

data_grid_id.Saggregate("aggregation_type_prefix.column_name BY group_by_field",true,false);

The following example illustrates how to use Saggregate function to create an aggregated DataGrid when creating applications using WebFOCUS Enable API.

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" creationComplete="initApp()" backgroundColor="#ffffff">  
 <mx:Script> 
  <![CDATA[ 
  import mx.charts.HitData; 
  import mx.controls.Alert; 
  import mx.collections.ArrayCollection; 
  public var grid1:ibiObject = new ibiObject(); 
  public var fex:String = "http://localhost:8080/ibi_apps/WFServlet?IBIF_ex=ggsales&IBIAPP_app=ibiflexdemo"; 
  public function initApp():void 
  { 
    grid1.init(fex,dataReady); 
  } 
  public function dataReady(grid:ibiObject,obj:*):void 
  {  

    grid1.populateGrid(false); 
    load_main1agg(); 
  } 
  public function load_main1agg():void 
  { 
    grid1.Saggregate("Sum.DOLLARS,Average.DOLLARS,Min.DOLLARS,Max.DOLLARS BY ST,REGION",true,false); 
    main1agg.dataProvider = grid1.prGridagg; 
  } 
  ]]> 
 </mx:Script> 
   <mx:DataGrid x="30" y="30" width="585" id="main1agg" height="355"> 
     <mx:columns> 
      <mx:DataGridColumn id="col1" headerText="Region" dataField="REGION" width="80"/> 
     <mx:DataGridColumn id="col2" headerText="State" dataField="ST" width="50"/>
     <mx:DataGridColumn id="col3" headerText="Total Sales" dataField="Sum.DOLLARS"/>      
     <mx:DataGridColumn id="col4" headerText="Minimum Sales" dataField="Min.DOLLARS"/> 
    <mx:DataGridColumn id="col5" headerText="Maximum Sales" dataField="Max.DOLLARS"/>
    <mx:DataGridColumn id="col6" headerText="Average Sales" dataField="Average.DOLLARS" width="150"/>      
  </mx:columns> 
 </mx:DataGrid>
</mx:Application>

The expected output is as follows.