cumulative sum of cumulative output

[anat]

Hi,

how to implement below scenario in qlikview

time	sal	cumulative sum		required output
period 1	100	100		100
period 2	10	110		210
period 3	20	130		340
period 4	100	230		340

if i select period 1 o/p=100

period 2 o/p=210(100+110)

period 3 o/p=340(100+110+130)

Regards

............

[sunny_talwar]

What is period 4 required output? 340 or 570?

[anat]

period 4 o/p=570

[Gysbert_Wassenaar]

Perhaps like this:

Data:

LOAD *, rangesum(cumsal, peek(req_out)) as req_out;

LOAD

     time,

     sal,

     rangesum(sal,peek(cumsal)) as cumsal

FROM ...

[nithin_miryala]

Hi Ananth,

Where you want to achieve this scenario (which object) ??

[anbu1984]

Check this app

[anat]

Thanks Gysbert,

in source i have only 2 columns(time,sal) ,remaining columns how to implement in qlikview report level( in text object)

[anat]

Hi @anbu

this is working fine  in table level ,same thing how  to implement in text object .

[anbu1984 · Accepted solution]

Check this app

[anat]

Thanks @anbu cheliyan

its working perfectly .............