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.
I had thought of doing it that way and maybe will in the future but I ended up being able to write a pretty quick recursive solution using the Move method. Hopefully this will suffice. Thanks for the response.