full accumalation in a pivot chart over the rows

[#1]

Hi,

I'll start with the script:

Data:
Load*,
Year & '-' & Month As Period
;
LOAD
RowNo() as RowID,
date(today() - RowNo(), 'DD MMM YYYY') as Date,
Month(today() - RowNo()) as Month,
Year(today() - RowNo()) as Year,
floor(rand() * 1000, 2) as Value,
right(RowNo(), 1) as Dim
AUTOGENERATE(1000);

I've two dimensions:

1. Dim

2. =Year & '-' & Month

I use one expression to accumalate per Row

rangesum(before(sum(Value),0, ColumnNo()))

How can I get an accumaltion for all the Dim over all rows?

[#2]

You have the options Accumulation which can be checked in the expression without any scripting.

Thanks,

SV

[#3]

You can refer to one of my previous posts on the same:

Monthly Cumulative for year as a field

[#4]

Hi,

The       RangeSum(Sales, Peek('CumAll')) as CumAll, in the load doesn't generate the expected values.

When I select Dim = 0, I see the expected Values, but when I select Dim = 0,1 then the accumulation starts for each row and not over all rows