Adding Totals for Year Sold on Item Number (1 Viewer)

yepwingtim

Registered User.
Local time
Today, 00:46
Joined
Jun 6, 2008
Messages
126
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!
 

Attachments

  • item_code.jpg
    item_code.jpg
    86.8 KB · Views: 237

kevlray

Registered User.
Local time
Today, 00:46
Joined
Apr 5, 2010
Messages
1,046
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.
 

Users who are viewing this thread

Top Bottom