title: Flex AdvancedDataGrid sort
body: <p>I have an AdvancedDataGrid that is being populated by customer data. Each customer has 3 monthly products(1, 3, 6), and also a <code>passed</code> field specifying whether the customer qualifies for any of the monthly products. </p>
  
  <p>Now the grid is sorting the customer data alphabetically, which is a good thing, but it isnt sorting the monthly products, not so good thing. </p>
  
  <p>The dataProvider looks something like this. (I am grouping by Funder.)</p>
  
  <pre><code>{Funder:"Customer1", Product:"1 Month", Passed:"False"}, 
  {Funder:"Customer1", Product:"3 Month", Passed:"True"}, 
  {Funder:"Customer1", Product:"6 Month", Passed:"True"}, 
  {Funder:"Customer2", Product:"1 Month", Passed:"False"}, 
  {Funder:"Customer2", Product:"3 Month", Passed:"False"}, 
  {Funder:"Customer2", Product:"6 Month", Passed:"False"}
  </code></pre>
  
  <p>Then results that I get in the grid looks something like this</p>
  
  <pre><code> ----------------------------------------
  | Funder &amp; Products   |  Product Passed  |
   ----------------------------------------
  | Customer1           |                  |
  |    6 Month          |  True            |
  |    3 Month          |  True            |
  |    1 Month          |  False           |
  | Customer2           |                  |
  |    3 Month          |  False           |
  |    6 Month          |  False           |
  |    1 Month          |  False           |
   ----------------------------------------
  </code></pre>
  
  <p>Any help on getting the products sorted as well?</p>
  
  <p><strong>EDIT:</strong></p>
  
  <p>Here is the code I use for the grid</p>
  
  <pre><code>&lt;mx:AdvancedDataGrid id="myADG" 
                       width="100%" height="100%"
                       initialize="gc.refresh();"
                       folderClosedIcon="{null}"
                       folderOpenIcon="{null}"
                       defaultLeafIcon="{null}"&gt;
  
      &lt;mx:dataProvider&gt;
          &lt;mx:GroupingCollection id="gc" source="{mCustomerData}"&gt;
              &lt;mx:grouping&gt;
                  &lt;mx:Grouping&gt;
                      &lt;mx:GroupingField name="Funder"/&gt;
                  &lt;/mx:Grouping&gt;
              &lt;/mx:grouping&gt;
          &lt;/mx:GroupingCollection&gt;
      &lt;/mx:dataProvider&gt;        
  
      &lt;mx:columns&gt;
          &lt;mx:AdvancedDataGridColumn dataField="Product" 
                                     headerText="Funder &amp;amp; Products"/&gt;
          &lt;mx:AdvancedDataGridColumn dataField="Passed"
                                     headerText="Product Passed"/&gt;
          &lt;mx:AdvancedDataGridColumn dataField="Passed"
                                     headerText="Product Failed"/&gt;
      &lt;/mx:columns&gt;
  &lt;/mx:AdvancedDataGrid&gt;
  </code></pre>