Stop Running Total When month has no value???

[dansbyd80]

Hello,

I have a data set where we are tracking an amount of spend monthly and would like it to be displayed in a running total and compared to the previous fiscal year. The pivoted data set looks like this.

Sum of Action Obligations Current	Column Labels
Row Labels	2011	2012
Oct	$217,969,612	$164,954,117
Nov	$264,784,595	$216,308,106
Dec	$512,178,568	$310,434,427
Jan	$502,173,051	$494,994,300
Feb	$380,427,951	$430,240,252
Mar	$532,243,129	$523,071,904
Apr	$480,922,657	$416,811,250
May	$481,191,267	$433,736,876
Jun	$500,609,436	$537,431,591
Jul	$658,326,510	$664,097,890
Aug	$617,390,860	$222,679,514
Sep	$1,952,408,207
Grand Total	$7,100,625,843	$4,414,760,227

<TBODY>
</TBODY>

After I change the value field settings to show a running total it shows this...

Sum of Action Obligations Current	Column Labels
Row Labels	2011	2012
Oct	$217,969,612	$164,954,117
Nov	$482,754,206	$381,262,224
Dec	$994,932,774	$691,696,651
Jan	$1,497,105,825	$1,186,690,951
Feb	$1,877,533,776	$1,616,931,203
Mar	$2,409,776,905	$2,140,003,106
Apr	$2,890,699,563	$2,556,814,356
May	$3,371,890,829	$2,990,551,232
Jun	$3,872,500,266	$3,527,982,823
Jul	$4,530,826,776	$4,192,080,713
Aug	$5,148,217,636	$4,414,760,227
Sep	$7,100,625,843	$4,414,760,227
Grand Total

<TBODY>
</TBODY>

As I am then charting off of this info I would like the FY12 September value to be blank. Otherwise it give the impression that the spend is expected to flatline for the rest of the year. I have tried working with a calculated field but I can seem to get it. Any ideas would be appreciated.

 

[bellman101]

You'll need to work the following into your formula:

=If(RANGE FOR SEPT=0,"",YOUR ORIGINAL FORMULA HERE)

You can then dollar the first part of the full month range and copy & paste formula.

Hope that is what you need

J