grouping on a condition.

I have some data issue as follows. We have some orders that had some items arrived at the customer damaged. We track such data.

I have made the cr by group1 = part#. the problem is that some orders they entered the same part same order they discovered damaged at different times. So in that case we have such data: so in this below case, we would want to see total of 9, we dont' need the breakout. The manager wants to know if damaged parts occurs on more than one order.

######## Figures Damaged Report 08/25/2015 - 09/23/2015 Part# Desc ORD# IDSHP# Ord Type FIAWDM FIAWDM ARM WRESTLING-3.5" DOUBLE MALE 05812657 1 COR FIAWDM ARM WRESTLING-3.5" DOUBLE MALE 05812657 8

COR

SO we want to see like here: here you have more than one order.

FIBADSM FIBADSM BASKETBALL-4.75" DRIBBLE MALE 05769499 18 FIBADSM BASKETBALL-4.75" DRIBBLE MALE 05812224 1