Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
hello see my explample. i think that is ok.
Maybe like
=aggr(rangesum(sum({<mese>}valore),above(sum({<mese>}valore))),mese)
as expression in the previously attached sample?
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
];
Unfortunately, i have a Personal Edition and i can't open the document.
Do you want "paste" the code here?
Thanks.
in your script put
rangesum(PROG,peek(PROG,-1)) as PROG;