sfriedman

Yes that worked, but I actually had to change the sort twice to get it to display correctly. I havde to fist change the hierarchy from primary sort month_num, and then employee ID; secobdary sort on sum_total_sales to employeeID, month_num, secondary sort on sum_total_sales. This changed the layout of the displayed info, but the sum_total_sales sort was correct. When I changed the primary sort back to the original configuration employeeID, month_num, secondary sort on sum_total_sales descending, it displayed correctly.

I've created a report and want to show the monthly sales by employees, but I want it ranked from highest to lowest value. My report consists of the following: sub-summary besed on Month_num (contains month name) sub-summary based on employee ID (shows firstname, lastname, summary_sales_total) No report body The report displays the information correctly showing each month followed by the employee and their aggregated sales totals for that month. My only problem is I want to sort it from highest ranking sales to lowest for each month. No matter how I've tried to sort it, it won't come out correctly.