Go to Reports > Financial > Item sales.
Generate the report on invoiced sales by client by selecting the start and end dates.
Set Invoice status filter Both. Select the department.
Group by invoice row and client.

Sales by client