Try something like this:
'Dummy' as Dummy,
Load Periode, Value, rangesum(peek('kum'), Value) as kum, rowno() as RowNo Resident t1;
drop table t1;
You might need further adjustments on the period and the cumulation don't need to be done within the script - with functions like:
rangesum(above(sum(value), 0, rowno(total)))
could this be done within the chart.
If you are having these provied fields in your data model we can create a line chart like this,
Back end :
Table: LOAD *, ID & Value as Period, AutoNumber(ID & Value,1) as PeriodNumber INLINE [ ID,Value WOG001 , 100 WOG002 , 150 WOG003 , 100 WOG004 , 150 WOG005 , 300 WOG006 , 150 WOG007 , 300 WOG008 , 150 WOG009 , 300 ];
Front End :
PFA for above Output.
If you need chart with month,Year more info by using a date field we can do it this way .
ID jan 2015 Feb 2015 jan 2016 Feb 2016 WOG001 2 4 7 8 WOG001 3 6 8 7
We can use cross table for it,
Hope this helps,
Line chart.qvw 152.8 K
have a look at the attached, using Crosstable as per Marcus, but with full accumulation on the Expressions tab of chart properties, for simplicity the value of 100 is applied for each WOG.
196974.qvw 151.0 K