Are you using a straight table? If yes, go to the Expressions tab in the chart Properties, click on the expression and tick the "Full Accumulation" check at the bottom of the dialog.
If you are using a pivot table instead, unless you allow the users to pivot the dimensions and expressions, the following should work
RangeSum(Above(Sum(Value), 0, RowNo()))
The Above() refers to the position of the dimension to aggregate, not to the column name, so that expression will work and return the same as the "Full Accumulation" mentioned above.
Hope that helps.
Thanks a lot for your help, but this method of calculation gives me results which depend from views and filters. I need to have contant results calculated only from transaction table.
When I click on row with 2010 I should have result:
Year Sum of Value Sum all Values till end of year 2010 3 10
but when I use your accumulation method I have:
Year Sum of Value Sum all Values till end of year 2010 3 4
which is wrong value.
Probably I should prepare this calculation during loading the script, but I'm looking for the solution to omit this.