Link to home
Start Free TrialLog in
Avatar of Clif
ClifFlag for United States of America

asked on

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.

TIA
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Clif

ASKER

Perfect!

Thanks.  :-)