Filter Database before grouping columns

Hi!   I have a database that I need to group by Order Number (because each order has several lines). The problem that I have is that sometimes, an order is related to 2 different work centers, so, ...