Conditional subtotals in crosstab?

[kunaljvora]

Hi,

I have a report with a crosstab having the following structure (data on the right, just giving the row structure):

Supplier A
Group1 Jan 11 Feb 11 ...
Level 1
P1 200 400
P2 300 500 ...
Level 2
P1
P2
Level 3
P1
P2
Level 4
P1
P2
Total@Group

Supplier B ...
.
.
.


Total@Group is the @Group level subtotal within the crosstab (not the grandtotal)

What I need is the Subtotal of the group should add the @Level totals of Level 1 and Level 2 but not Level 3 and 4.

Is there a way to do this in crystal? Can I have a conditional formula on the subtotals in crosstab?

All I can do is either supress the subtotal altogether or have it with the total of Level 1, 2, 3 and 4. But I only want the total to add Level 1 and 2.

Please help! I am using Crystal Reports XI

Thanks in advance

Kunal

 

[lbass]

I responded to your earlier post in your older thread.

-LB