I have a report that is grouped by Customer Name(group 1) and Site Name (group 2). Then I am trying to do a Group Sort based on an average that I inserted into the Customer Name Group Footer(group1). It does not work and only sorts by customer name. Any suggestions or workarounds would be greatly appreciated.

Click image for larger version. 

Name:	DataFlex Reports Screenshot.PNG 
Views:	109 
Size:	21.4 KB 
ID:	13928