<?xml version="1.0" encoding="utf-8"?>

<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute">

	<mx:AdvancedDataGrid x="10" y="10" id="adg1" designViewDataType="tree" width="522" height="322"

						 creationComplete="gc.refresh();" headerSortSeparatorSkin="mx.skins.ProgrammaticSkin">

		<mx:dataProvider>

			<mx:GroupingCollection id="gc" source="{dpFlat}">

				<mx:Grouping>

					<mx:GroupingField name="fParent" descending="false">                      	

						<mx:summaries>      		

							<mx:SummaryRow summaryPlacement="group">

								<mx:fields>

									<mx:SummaryField dataField="Actual" operation="SUM" label="Actual"/>

									<mx:SummaryField dataField="Estimate" operation="SUM" label="Estimate"/>

								</mx:fields>

							</mx:SummaryRow>

						</mx:summaries>

					</mx:GroupingField>

				</mx:Grouping>

			</mx:GroupingCollection>

		</mx:dataProvider> 

		<mx:groupedColumns>

			<mx:AdvancedDataGridColumn headerText="fCode" dataField="fCode"/>

			<mx:AdvancedDataGridColumn headerText="Territory_Rep" dataField="Territory_Rep"/>

			<mx:AdvancedDataGridColumnGroup headerText="组合">

				<mx:AdvancedDataGridColumn headerText="Actual" dataField="Actual"/>

				<mx:AdvancedDataGridColumn headerText="Estimate" dataField="Estimate"/>

			</mx:AdvancedDataGridColumnGroup>	

		</mx:groupedColumns>

		

	</mx:AdvancedDataGrid>

	

	<mx:Script>

		<![CDATA[

			import mx.charts.ColumnChart;

			import mx.charts.series.ColumnSeries;

			import mx.collections.ArrayCollection;

			import mx.collections.GroupingField;

			

			[Bindable]

			private var dpFlat:ArrayCollection = new ArrayCollection([

				{fCode:"101", fParent:" ", 

					Territory_Rep:"Barbara Jennings", Actual:38865, Estimate:40000}, 

				{fCode:"10101", fParent:"101", 

					Territory_Rep:"Dana Binn", Actual:29885, Estimate:30000},  

				{fCode:"10102", fParent:"101", 

					Territory_Rep:"Joe Smith", Actual:29134, Estimate:30000},  

				{fCode:"201", fParent:" ", 

					Territory_Rep:"Bethany Pittman", Actual:52888, Estimate:45000},  

				{fCode:"20101", fParent:"201", 

					Territory_Rep:"Lauren Ipsum", Actual:38805, Estimate:40000}, 

				{fCode:"20102", fParent:"201", 

					Territory_Rep:"T.R. Smith", Actual:55498, Estimate:40000},  

				{fCode:"301", fParent:" ", 

					Territory_Rep:"Alice Treu", Actual:44985, Estimate:45000}, 

				{fCode:"401", fParent:" ", 

					Territory_Rep:"Jane Grove", Actual:44913, Estimate:45000}

			]);

			

			private function gf(item:Object, field:GroupingField):String{

				return item[field.name];

				

			}

		]]>

	</mx:Script>

	

</mx:Application>