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)