Sort Summary highest to lowest values

[sfriedman]

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.

[comment]

See if this helps:

http://www.filemaker.com/help/html/find_sort.5.22.html#1029044

[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.