Subtotals within a Group

[ajxmas]

Hi all, using CR11 - Oracle DB

Report Looks like this:

Group 1...
Group 2...
Group 3
.... Issue 25.00
.... Sale 10.00
.... Issue 11.00
.... Entry 5.00
.... Sale 30.00
.... Sale 1.00

I need to add count & sum subtotals in my Group3 footer that looks like this:
Issue 2 36.00
Sale 3 41.00
Entry 1 5.00

I can't seem to get this with the basic Insert Summary or Running Totals. How should I go about it?

PS... I need to do the same for Group 2 & Group 1 adding each level up.

 

[ajxmas]

Just to add, I tried including another group but that breaks up my detail section which is not what I want

 

[lbass]

Insert a crosstab in your Group# 3 footer that uses whatever field results in "Issue","Sale", etc., as the row field, and add the count and sum summary fields. You can copy this into other group footers and the report footer if you wish.

-LB

 

[ajxmas]

Thanks so much lbass, I'll give that a try.