I have created a ReportSmith report for selected employees and need to have each employees "total Gross Checks" for the period of time that is selected in a Report Variable to be sorted in Decending order. I have set up a Report Grouping by employee name and put the total of checks in a footer (hiding section detail), but am at a loss on how to set up a Macro Derived Field so I can sort each employee by who has received the combined highest to lowest gross pay. Any help would be greatly appreciated!