Dear All,

                   I hav to find the total of a amount value based on the itemcode.How to achieve that in Crystal report.

Scenario:

perticulars                                  amount

1              sharemoney                           100             

                compdeposit                              20

              regulardeposit                          30

2              sharemoney                10

B               compdeposit                20

Now i have to find the group total based on thefields: Like sharemoney:150    and compdeposit:30 which should come like mentioned below

1                  perticulars          amount:150

              sharemoney              100             

              compdeposit                20

             regulardrposit                30

B                    perticulars                    amount:30

               sharemoney                              10

               compdeposit                                 20

Can anybody pls tell me how to acieve this....