running totals in cross-tabs

[nekkanti03]

Hi

In of the report I'm using crosstab. here is the scenario


july ytd aug ytd sep ytd
xyz 100 100 0 0 200 300
pqr 300 300 0 0 400 700

SO here in cross-tab, xyz and pqr are the rows and months and YTD are columns and Amount as summarizing field.
Here in cross tab YTD column is a running total which need to calculate runningt otal of months.
see the above table, For july the amount is 100 and YTD(running total) is showing as 100 for second column AUG the amount is 0 and YTD(running total) should show as 100. But here its showing as 0. i need to show YTD(running total) as 100 for Aug.

How to change the running total from 0 to 100 in second column?
can anybody help me out?

 

[IanWaterman]

its because you have no data in Agust and its returning a null.

Try using a formula instead of your current valuefield

@value
If isnull(valuefield) then 0 else valuefield.

Ian