AdvancedDataGrid with SummaryField : AdvancedDataGrid « Grid « Flex

1. Flex
2. Grid
3. AdvancedDataGrid

AdvancedDataGrid with SummaryField

      
<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" width="600" height="300" >
<mx:Script>
    
        import mx.collections.ArrayCollection;
        [Bindable]
        private var grocerySalesData:ArrayCollection = new ArrayCollection([
            {Grocer:"A", Category:"X", Item:"Apple", Q1:15, Q2:10},
            {Grocer:"A", Category:"X", Item:"Banana", Q1:25, Q2:15},
            {Grocer:"A", Category:"Y", Item:"Chicken", Q1:35, Q2:42},
            {Grocer:"A", Category:"Y", Item:"Beef", Q1:42, Q2:35},
            {Grocer:"B", Category:"X", Item:"Apple", Q1:17, Q2:12},
            {Grocer:"B", Category:"X", Item:"Pineapple", Q1:17, Q2:15},
            {Grocer:"B", Category:"Y", Item:"Pork", Q1:43, Q2:43}
        ]);
  
</mx:Script>
    <mx:AdvancedDataGrid id="myAdvancedDG" width="100%" height="100%" defaultLeafIcon="{null}" initialize="gc.refresh();">
        <mx:dataProvider>
            <mx:GroupingCollection2 id="gc" source="{grocerySalesData}">
                <mx:Grouping>
                    <mx:GroupingField name="Grocer">
                    <mx:summaries>
                          <mx:SummaryRow summaryPlacement="group">
                            <mx:fields>
                                <mx:SummaryField dataField="Q1" label="Q1 Total" operation="SUM"/>
                                <mx:SummaryField dataField="Q2" label="Q2 Total" operation="SUM"/>
                            </mx:fields>
                          </mx:SummaryRow>
                        </mx:summaries>
                    </mx:GroupingField>
                    <mx:GroupingField name="Category">
                    <mx:summaries>
                          <mx:SummaryRow summaryPlacement="group">
                            <mx:fields>
                                <mx:SummaryField dataField="Q1" label="Q1 Total" operation="SUM"/>
                                <mx:SummaryField dataField="Q2" label="Q2 Total" operation="SUM"/>
                            </mx:fields>
                          </mx:SummaryRow>
                        </mx:summaries>
                    </mx:GroupingField>
                </mx:Grouping>
            </mx:GroupingCollection2>
        </mx:dataProvider>
        <mx:columns>
            <mx:AdvancedDataGridColumn dataField="GroupLabel" headerText="Grocer/Category"/>
            <mx:AdvancedDataGridColumn dataField="Item" headerText="Product(Item)"/>
            <mx:AdvancedDataGridColumn dataField="Q1"/>
            <mx:AdvancedDataGridColumn dataField="Q2"/>
            <mx:AdvancedDataGridColumn dataField="Q1 Total"/>
            <mx:AdvancedDataGridColumn dataField="Q2 Total"/>
        </mx:columns>
   </mx:AdvancedDataGrid>
</mx:Application>

   
    
    
    
    
    
  

Related examples in the same category

1.	Use HierarchicalData.childrenField to specify the name of the field that defines the hierarchy
2.	Hierarchical AdvancedDataGrid TreeColumn
3.	AdvancedDataGrid with four columns
4.	Using AdvancedDataGrid to show hierarchical data
5.	Setting up the AdvancedDataGrid with dataField and headerText
6.	AdvancedDataGrid and column grouping
7.	ArrayCollection and AdvancedDataGrid
8.	Call invalidateList to refresh and apply the style to the AdvancedDataGrid
9.	Use styleFunction to apply style to AdvancedDataGrid based on conditions
10.	Cut and paste cell for AdvancedDataGrid the TextArea control located at the bottom of the application:
11.	Allow Multiple Selection for AdvancedDataGrid
12.	AdvancedDataGrid with With Hierarchical Data
13.	Fill data from XML to AdvancedDataGrid
14.	Change column header for Hierarchical AdvancedDataGrid
15.	Hierarchical AdvancedDataGrid Categories
16.	Displaying hierarchical XML data and use it in AdvancedDataGrid
17.	Group AdvancedDataGrid with MXML Default Properties
18.	An AdvancedDataGrid that displays two summary fields, Min Actual and Max Actual
19.	Summary Column with AdvancedDataGrid
20.	Summary AdvancedDataGrid with SummaryRow and SummaryField2
21.	implements the AdvancedDataGrid control shown in the previous figure:
22.	Regrouping AdvancedDataGrid
23.	Advanced DataGrid Demo
24.	Advanced DataGrid with Model Data
25.	Advanecd DataGrid for NestedGroups
26.	Hierarchical Advanced DataGrid Column Grouping