Difference in crosstab

[dogmac]

Hi, I was wondering if anyone had a brilliant solution for me.

 

I have a crosstab of date and types such as below

 

Code:

                type1                  type2
       Activated | Deactivated   Activated| Deactivated
date1      12    |     1            123      16
date2      1234  |     123

etc, etc

 

What I want is to put a total for each type which is the difference between activated and deactivated.

 

I've tried negating deactivated, and then summing, but it seems to only take the positive option. ie Sum (12, -1) = 13 not 11.

 

Is there any way that I can do this? Because there are several types for the same date, and we want to compare all of them, a crosstab seems to be the sensible way to go (tried columns as well), but the difference is failing me miserably.

 

HELP!!

 

thanks in advance

 

Di

Post edited by: dogmac, at: 2007/06/29 00:36