I am not even sure if this is possible, but here it comes anyways. I have two arrays that I am using to create a the dataprovider for a datagrid. The first grid tranMonth holds the data for the dynamic columns that I am creating. It holds the column header, and data field.
The second grid holds all the data that is populating the datagrid. It looks something like this transData(sort:2007, janTotal:0, febTotal:5, etc....). The over all sort that I am trying to do is allow the user to sort by the year they select. So that the month(column) with the most transactions now becomes the first column in the grid. Any help with this would be greatly appreciated.
