Clif
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:
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks. :-)