CR9-Cross Tab Running Total/Average

[JoyCR9]

My Crystal Report (v9) is a distinct count of service call ids per month.

Group Name 1 is Service_Call.Create_Dt
Group Name 2 is @Vendor
@Vendor is:
if {PART.PART_VENDOR_ID}=109
then "NETWORK"
else "UNIX"
Group Name 3 is Service_Call.Service_Call_ID

In the Cross Tab I use a formula to break calls out by geographical location with the final two columns being TOTAL and AVERAGE. The row is Service_Call.Create_Dt grouped by month. Within that row is the Distinct count of service call ids per geographical region based on @Vendor.

This gives me the following output:

Calgary Canada USA Total AVG
Jan calls 1 1 1 3 1
Feb calls 2 2 2 6 2
Mar calls 3 3 3 9 3
and so on

What my boss really wanted was
Calgary Canada USA Total AVG
Jan calls 1 1 1 3 1
Feb calls 2 2 2 9 3
Mar calls 3 3 3 18 6
and so on

How do I achieve this?

Thanks,
Joy

 

[Madawc]

Do you mean, you want January, Jan-Feb, Jan-Feb-March etc.?

If so, I don't think you can do that in a crosstab. You may need to write a 'mock crosstab', a grid of running totals that look like a crosstab, but you have to create every single one of them yourself.

Madawc Williams (East Anglia, UK)