Multiple sub-totals printed w/in Group

[GuyHamasaki]

Is it possible to print more than one sub-total within a group. I have a report Grouped by Month--January, February, etc... The report needs to provide a sum for each quarter. Example...

January 10 11 12
February 10 11 10
March 9 2 1
QTR 1 29 24 23
April 10 11 12
May 10 11 10
June 9 2 1
QTR 2 29 24 23
etc...

The numbers for each month are counts of the data. I use the following formula below to determine if the record needs to be counted and then insert a summary count, which is what you see in the example above.

if {field} = 'Blah' then
1
else
0

Currently, the report looks the example above w/out the QTR totals.

What is the best/simplest way to make the report include the QTR sub-totals?

Regards,

Guy

 

[dgillz]

Create a formula field called quarter and use if-then logic to assign the quarter to each record.

If Month(fieldname) in 1 to 3 then "1st Qtr" else
If Month(fieldname) in 4 to 6 then "2nd Qtr" else
If Month(fieldname) in 7 to 9 then "3rd Qtr" else
if Month(fieldname) in 10 to 12 then "4th Qtr"

Then group by Quarter in addition to your group by month.

Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com