Custom Soring in GroupBy and Sorting in gridControl of deveXpress

Hi

We want to sort the grid view with other columns other than group by which will sort the group by rows first and then the detail level rows. Currently the default sorting will sort the group by column and then sorts the other columns with in the group by columns.

For, eg.. Our resultset is having 3 columns named CompanyName, Investment Date and Investment amount and the results are group by CompanyName in the grid view. When we want to sort the grid using InvestmentAmount, it is sorting the companies first using company name and then the investment amount are getting sorted only in the detail level, whereas we want to sort the group by row..ie companies by Investment Amount. Please let me know if you need more clarifications.