Skip to Content
author's profile photo Former Member
Former Member

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
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Nov 10, 2015 at 10:03 PM

    Group by Order Number inside the group by Part Number. Then take the data out of the details section and put it in the Order Number group footer. Suppress the Order Number group header and the Details sections. Instead of using the quantity from the data, use a Summary to Sum() the quantities per order.

    -Dell

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.