im new to using crystal and have a problem i hope someone can help with.

i am reading in sales reps sales and need to display just the product name and the total quantity, but what i am displaying is the product name and each sale with a running total i have created that increments with each sale

i am not doing anythin fancy with the running total just summarizing one field with sum and resetting it on change of field

 

for example:

`

                          my running total

 

coke                                10

                                       22

                                       25

 

pepsi                                4

                                       17

                                       28

 

i need to display them with just the totals e.g.

 

coke                 25

 

pepsi                28

 

any help would be great with this

 

thanks in advance