Skip to Content

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

Subtotal on every group code

Morning all,

I have created a report which is grouped by Reason Code (A numbering system 01- 999). This report produces Total Jobs, Total Lenses and their averages.

There is one slight addition I would like to add into the report.

I would like to create a formula so that report sub totals each record according to the code range.

For example:

When producing report for all codes (01- 999) It should produce results like this.

01 to 99

Sub Total

100 to 199

Sub total

200 - 299

Subtotal

and so on (upto 999).

Then Grand total of everything.

Any ideas how to achieve something like this?

Report Layout:

Grouped by - Reason code 01- 999

Group Header = Reason Code and Reason Description

Group Footer = Total Jobs, Total Lenses, Total Average

Report Footer = Total of Total Jobs, Total of Total Lenses and avg

Currently report when produced, it produces results like this

01 - 999

Total lenses, jobs and averages.

Hence there is no sub division between code ranges.

Could someone advise me on this please?

Many thanks

Regards

Jehanzeb

Former Member
replied

Insert new group and insert summary to get sub totals.

Thanks,

Sastry

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question