Running Total in Cross Table does not consider zero values

Hi to all,

I have created a cross table with Crystal R. 2008 SP1 fix pack 1.3 (that is version 12.1.3.1028).

In this cross table I have used period of time as column (in month/year format) and product categories as rows. I have summarized product quantites per each category/period by using the wizard running total. This running total has been setted to evaluate each record but to be resetted when row changes so when product category changes.

Example: i have 4 periods (1/09, 2/09, 3/09, 4/09) and different categories (A, B). Quantities for a category (i.g. A) are as follows:

category A, period 1/09, qty = 10

category A, period 2/09, qty = 0

category A, period 3/09, qty = 7

category A, period 4/09, qty = 3

Running total displays:

category A, period 1/09, qty = 10

category A, period 2/09, qty = 0

category A, period 3/09, qty =17 (i.e. 10 + 7)

category A, period 4/09, qty = 20 (i.e. 17 +3)

So the running total works but does not consider the period where data (qty) is 0. I want running total to continue summarizing data even in this case so I will get:

category A, period 2/09, qty = 10 (i.e. 10 +0).

Is there any setting to get this result?

Thank you

Iris