<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" creationComplete="init()">
  <mx:Script>
   <![CDATA[
   	import mx.collections.XMLListCollection;
   	
      [Bindable]
      public var dataXML:XML = 
<ROWSET>
<ROW>
<NAME>Pat Fay</NAME>
<FIRST_NAME>Pat</FIRST_NAME>
<LAST_NAME>Fay</LAST_NAME>
<SALARY>6000</SALARY>
<ANNUAL_SALARY>72000</ANNUAL_SALARY>
<FED_WITHHELD>20160</FED_WITHHELD>
<JOB_TITLE>Marketing Representative</JOB_TITLE>
<DEPARTMENT_NAME>Marketing</DEPARTMENT_NAME>
<MANAGER>Michael Hartstein</MANAGER>
</ROW>
<ROW>
<NAME>William Gietz</NAME>
<FIRST_NAME>William</FIRST_NAME>
<LAST_NAME>Gietz</LAST_NAME>
<SALARY>8300</SALARY>
<ANNUAL_SALARY>99600</ANNUAL_SALARY>
<FED_WITHHELD>27888</FED_WITHHELD>
<JOB_TITLE>Public Accountant</JOB_TITLE>
<DEPARTMENT_NAME>Accounting</DEPARTMENT_NAME>
<MANAGER>Shelley Higgins</MANAGER>
</ROW>
<ROW>
<NAME>Matthew Weiss</NAME>
<FIRST_NAME>Matthew</FIRST_NAME>
<LAST_NAME>Weiss</LAST_NAME>
<SALARY>8000</SALARY>
<ANNUAL_SALARY>96000</ANNUAL_SALARY>
<FED_WITHHELD>26880</FED_WITHHELD>
<JOB_TITLE>Stock Manager</JOB_TITLE>
<DEPARTMENT_NAME>Shipping</DEPARTMENT_NAME>
<MANAGER>Steven King</MANAGER>
</ROW>
<ROW>
<NAME>Adam Fripp</NAME>
<FIRST_NAME>Adam</FIRST_NAME>
<LAST_NAME>Fripp</LAST_NAME>
<SALARY>8200</SALARY>
<ANNUAL_SALARY>98400</ANNUAL_SALARY>
<FED_WITHHELD>27552</FED_WITHHELD>
<JOB_TITLE>Stock Manager</JOB_TITLE>
<DEPARTMENT_NAME>Shipping</DEPARTMENT_NAME>
<MANAGER>Steven King</MANAGER>
</ROW>
<ROW>
<NAME>Payam Kaufling</NAME>
<FIRST_NAME>Payam</FIRST_NAME>
<LAST_NAME>Kaufling</LAST_NAME>
<SALARY>7900</SALARY>
<ANNUAL_SALARY>94800</ANNUAL_SALARY>
<FED_WITHHELD>26544</FED_WITHHELD>
<JOB_TITLE>Stock Manager</JOB_TITLE>
<DEPARTMENT_NAME>Shipping</DEPARTMENT_NAME>
<MANAGER>Steven King</MANAGER>
</ROW>
<ROW>
<NAME>Shanta Vollman</NAME>
<FIRST_NAME>Shanta</FIRST_NAME>
<LAST_NAME>Vollman</LAST_NAME>
<SALARY>6500</SALARY>
<ANNUAL_SALARY>78000</ANNUAL_SALARY>
<FED_WITHHELD>21840</FED_WITHHELD>
<JOB_TITLE>Stock Manager</JOB_TITLE>
<DEPARTMENT_NAME>Shipping</DEPARTMENT_NAME>
<MANAGER>Steven King</MANAGER>
</ROW>
<ROW>
<NAME>Kevin Mourgos</NAME>
<FIRST_NAME>Kevin</FIRST_NAME>
<LAST_NAME>Mourgos</LAST_NAME>
<SALARY>5800</SALARY>
<ANNUAL_SALARY>69600</ANNUAL_SALARY>
<FED_WITHHELD>19488</FED_WITHHELD>
<JOB_TITLE>Stock Manager</JOB_TITLE>
<DEPARTMENT_NAME>Shipping</DEPARTMENT_NAME>
<MANAGER>Steven King</MANAGER>
</ROW>
<ROW>
<NAME>Eleni Zlotkey</NAME>
<FIRST_NAME>Eleni</FIRST_NAME>
<LAST_NAME>Zlotkey</LAST_NAME>
<SALARY>10500</SALARY>
<ANNUAL_SALARY>126000</ANNUAL_SALARY>
<FED_WITHHELD>35280</FED_WITHHELD>
<JOB_TITLE>Sales Manager</JOB_TITLE>
<DEPARTMENT_NAME>Sales</DEPARTMENT_NAME>
<MANAGER>Steven King</MANAGER>
</ROW>
<ROW>
<NAME>Gerald Cambrault</NAME>
<FIRST_NAME>Gerald</FIRST_NAME>
<LAST_NAME>Cambrault</LAST_NAME>
<SALARY>11000</SALARY>
<ANNUAL_SALARY>132000</ANNUAL_SALARY>
<FED_WITHHELD>36960</FED_WITHHELD>
<JOB_TITLE>Sales Manager</JOB_TITLE>
<DEPARTMENT_NAME>Sales</DEPARTMENT_NAME>
<MANAGER>Steven King</MANAGER>
</ROW>
<ROW>
<NAME>John Russell</NAME>
<FIRST_NAME>John</FIRST_NAME>
<LAST_NAME>Russell</LAST_NAME>
<SALARY>14000</SALARY>
<ANNUAL_SALARY>168000</ANNUAL_SALARY>
<FED_WITHHELD>47040</FED_WITHHELD>
<JOB_TITLE>Sales Manager</JOB_TITLE>
<DEPARTMENT_NAME>Sales</DEPARTMENT_NAME>
<MANAGER>Steven King</MANAGER>
</ROW>
</ROWSET>
;

		[Bindable]
		public var filteredXML:XMLListCollection = new XMLListCollection(dataXML.ROW);
		public function init():void{
			filteredXML.refresh();
		}
	
	]]>
 </mx:Script>
  <mx:Panel x="0" y="0" width="100%" height="504" layout="absolute">
    <mx:VBox x="0" y="0" width="100%" height="100%">
    	<mx:DataGrid x="10" y="160" width="476" height="152" dataProvider="{filteredXML}"> 
  			<mx:columns>
		    	<mx:DataGridColumn headerText="Employee" dataField="NAME" />
		    	<mx:DataGridColumn headerText="Title" dataField="JOB_TITLE"/>
		    	<mx:DataGridColumn headerText="Monthly Salary" dataField="SALARY"/>
		    	<mx:DataGridColumn headerText="Annual Salary" dataField="ANNUAL_SALARY"/>
		  	</mx:columns>
		</mx:DataGrid>
      <mx:ColumnChart x="10" y="10" id="columnchart1" width="476" height="142" dataProvider="{filteredXML}"> 
   		<mx:horizontalAxis>
     		<mx:CategoryAxis  categoryField="NAME" />
   		</mx:horizontalAxis>
   		<mx:series >
     		<mx:ColumnSeries xField="NAME"  yField="SALARY" displayName="Salary"/>
   		</mx:series>
		</mx:ColumnChart>
	<mx:Legend dataProvider="{columnchart1}" x="383" y="10"/>
    </mx:VBox>
  </mx:Panel>
</mx:Application>
