How to Sum Crosstab even if you can't / 0

[antexity]

Hello All,

Hopefully this is possible.   I have a rolling 13 month crosstab.  Everything is working great.   What I would like is the following:

Currently if I run the report I get the following output:

Apr10	May10	Jun10	Jul10	Aug10	Sep10	Oct10	Nov10	Dec10	Jan11	Feb11	Mar11	Apr11	May11	Rolling AVG
$2343	$1234	****	$2435	$2342	$2652	$1234	$4321	$2345	$5432	****	$2343	$2343	$2343	$2343

The ****, I placed those in as a value when it cannot divide by Zero.  The Measure I have is:

Measure = ['A'] / ['B']

Now when I calculated the Rolling Avg, it only calculates the totals that have a answer it does not incl the ****, make sense.  But I would like to do is actually calculate all the ['A'] / all the ['B'] as a whole even though ['B'] is zero sometimes. Therefore Sum up all the ['A'] for the Rolling 13, Value or no value / sum up all the ['B'] value or no value.

Hopefully that makes sense and that there is a solution,

Thank you!
Jonathan

[antexity]

Does anyone know if this can be done?

Thanks,
Jonathan