• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

Summing Subtotals

I'm using Crystal XI

Ok, so maybe "summing subtotals" isn't quite right, but I can't think of another way to say it.

What I have is a report listing parts grouped by assembly, something like this:
Part No    Color     Assembly    Price
12345      Black     ABC         $123.45
12345      White     ABC         $123.45
12345      Silver    ABC         $123.45
98765      White     ABC         $123.45
98765      Black     ABC         $123.45
98765      Silver    ABC         $123.45
Assembly ABC Subtotals
Count of Unique Parts:  2
Subtotal of Price: $740.70

12345      Black     XYZ         $123.45
12345      White     XYZ         $123.45
12345      Silver    XYZ         $123.45
24568      White     XYZ         $123.45
24568      Black     XYZ         $123.45
24568      Silver    XYZ         $123.45
Assembly XYZ Subtotals
Count of Unique Parts:  2
Subtotal of Price: $740.70

Grand Totals:
Count of Unique Parts:  4
Subtotal of Price: $1481.40

Open in new window

The last part is where I'm having trouble.  Specifically the "Grand Total Count of Unique Parts".  What I want is a sum of each subtotal count.  Or, to look at it another way, a unique count of Part Number/Assembly.

1 Solution
You hit it with your unique count of Part Number/Assembly.

Create a formula

{PartNumber} & {Assembly}

DO a distinct count on that

ClifAuthor Commented:

Thanks.  :-)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now