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.