report sort by summary
I am stumped on this and cant seem to find a solution searching through the forum. i am sure there is an easy way to do what i want.
I have data in a table that i use a summary field to generate averages for some of the fields. what i want to be able to do is sort the information in a report layout according to the values of one of the summary fields. when i try to select the field to sort by the option i wish to use it is greyed out and unselectable.