Cumulate Column

[#1]

Hello,

I have one column (dimension) Year and in the rows i have the months e.g.

          2015          cum.     2014     cum.

oct          10         100          50      140

sept         20        90            40       90 

aug          30        70            30       50 

jul            40        40            20       20

what is the formula for the cumulate column?

[#2]

Just copy the formula you use for 2015 and check the full accumulation box in the expression properties.

See attached

[swuehl]

You can use chart inter record functions like above() or below() in combination with rangesum().

Something like

=Rangesum( Above( Sum( ValueField), 0, RowNo() )

or

Rangesum(Below(Sum(TypeID),0,NoOfRows()  ))

[depending on month sort order]

[Anonymous]

Hi ,

Here  is the attached QVW .

with both accumulation function in Straight table and Range sum in Pivot table .

I think this helps .

Thanks,

Bunny