Subtotal on every group code
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.
When producing report for all codes (01- 999) It should produce results like this.
01 to 99
100 to 199
200 - 299
and so on (upto 999).
Then Grand total of everything.
Any ideas how to achieve something like this?
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?