I need Year Sold Totals for the Item Number

for example,

42AG, 42AP, 42BO, 42MG = 126
4204AC, 4204AG, 4204AP, 4204BO, 4204LAG, 4204LAS, 4204MG, 4204MS, 4204RAW = 475

I'm not sure how crystal reports would group them together and add them up depending just on the item number range.

Thanks for the input guys!

Not sure how you are determining your totals. But as far as grouping. If there is a pattern to follow, you can create a formula and group on that formula. If then else statements can define your 'groups'.

I hope this helps.