# 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
``````

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
LVL 10
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
You hit it with your unique count of Part Number/Assembly.

Create a formula

{PartNumber} & {Assembly}

DO a distinct count on that

mlmcc
0

Experts Exchange Solution brought to you by