Progressive Month

[#1]

I have to create a derived field, which is a progressive on the month, accumulated up to the current month.

Example: Jan -> 1000, Feb -> 200; Mar -> 400; Apr -> 650.

The sequence should be: Jan -> 1000, Feb -> 1200; Mar -> 1600, April -> 2250.

I attach a screen. The field "(progressivo mese)" is what I get.

Solutions?

Thank you.

[nagaiank]

In a straight table chart use the following settings:

Dimension: Month

Expression: Sum(Value) and select Full Accumulation in the Accumulation window

This will generate table with cumulative values.

[#3]

Thanks a lot.

It's worked.

But i have another question, because the problem is solved only in part.

When i select a month, example Giu, i lost the information accumulated, because the system result only value linked with Giu and not the values linked to Mag+Giu.

Is it possible to resolve this problem?

I load an image that explain this concept.

Thanks you.

[#4]

hello see my explample. i think that is ok.

[swuehl]

Maybe like

=aggr(rangesum(sum({<mese>}valore),above(sum({<mese>}valore))),mese)

as expression in the previously attached sample?

[#6]

from script

tab:

LOAD *,

rangesum(valore,peek('valore',-1)) as valorecum;







LOAD * INLINE [

    mese, valore

    gen, 1

    feb, 2

    mar, 3

    apr, 4

    mag, 5

    june, 6

    lu, 7

    ag, 8

    set, 9

    ott, 10

    nov, 11

    dic, 12

];

[#7]

Unfortunately, i have a Personal Edition and i can't open the document.

Do you want "paste" the code here?

Thanks.

[#8]

in your script put

rangesum(PROG,peek(PROG,-1)) as PROG;