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