March 23, 200916 yr Newbies 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.
March 23, 200916 yr See if this helps: http://www.filemaker.com/help/html/find_sort.5.22.html#1029044
March 23, 200916 yr Author Newbies 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.
Create an account or sign in to comment