I have a request to sort columns by the summary value of the column and not the value of the rows used in calculating that summary.
Example. Columns are grouped by Type ascending and sorted by Number ascending. This would be default grid behavior:
Type Name Number
Dummy 1 25 <-summary value for number
Name 3 10
Name 4 15
Dummy 2 8
Name 1 1
Name 2 7
However with my sorting I would like it to appear like this:
Dummy 1 25
Where would I begin to implement something like this?
Always seem to find what I'm looking for right after I post. The solution I found lies within the Move method of the RowsCollection object, if anyone knows of a better way please let me know.
I beleive you could also do this using the GroupBySortComparer on the column.