Top N of groups by a %age

[johnstrang]

Hi,

I hope someone can help me with this.

I have a situation where various departments are allocated Work Orders.

I group by Department, and count the Orders by department.
I also have a formula that determines if the order is closed before Due Date:
if close_date <= due_date then 1 else 0

I then sum the Orders closed by due_date.

For Example
Dept D1 has 5 Orders, 2 Closed by due_date (ie 40%)
Dept D2 has 10 orders, 5 Closed by due_date (ie 50%)
Dept D3 has 20 Orders, 4 Closed by due_date (ie 25%)

I can sort the departments by either
Count of Orders = D3 D2 D1
Sum of Orders closed by due_date = D2 D3 D1

But I want the % of orders closed by due_date = D2 D1 D3

If anyone can help I'd be very grateful,

John