Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to find group wise total in crystal report?

Dear All,

                   I have to find the total of a Quantity value based on the Item code.How to achieve that in Crystal report.


Itemcode   orderno     Qty

A               1             100

A               2               20

A               3               30

B               1                10

B               2                20

Now i have to find the group total based on the Item code: Like A:150    and B:30 which should come like mentioned below

A                   Total     150

A               1               100

A               2                 20

A               3                 30

B                    Total      30

B               1                 10

B               2                 20

Can anybody pls tell me how to solve this?

Former Member
Former Member replied

Hello Guys,

What we wanted in our output is to have a single line item for each item that we had in the picklist.

to get this output. we changed the details of headers and footers in the report. like the sum of each item group was placed in header. due to which the repeated item were shown only once and we were to get our required output.

Thank you all for your help.

thanks and regards,


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question