Utilize the AppExchange to download a third-party application that can roH up the sales dollars with the appropriate filter.

Create a master-detail relationship between the parent and child object with a roll-up summary field that fitters on the status held.

Create a lookup relationship between the parent and child object with a roll-up summary held that filters on the status field.

Utilize Apex code to roll up the desired amounts.