Thanks to everyone who helped me earlier. I’m faced with a different problem now. I am grouping a datagrid by one column, but I’d like to sort by the highest value in another column of each grouping. Every row in a group is related. A simple example would be to list the store chains and city they are in who bought your product.
Gifts Galore / New York / 50,000
Gifts Galore / Chicago / 45,000
Gifts Galore / Kansas City / 40,000
Book Palace / Tampa Bay / 47,000
Book Palace / Chicago / 40,000
Book Palace / Houston / 39,000
Book Palace / Seattle / 35,000
The highest value in each group counts for the group sorting, then by the value within each group. I’m not sure how do to that.
Thanks in advance.
Imported from legacy forums. Posted by moquif (had 1987 views)