pivot table sum before data

[Anonymous]

hello,

i have the first table in qlikview, and i would like to get the second one.

¿can you help me?

Year_Month	Months	0	1	2
201701		432	42	32
201702		542	2	-
201703		54	-	-
Year_Month	Months	0	1	2
201701		432	474	506
201702		542	544	-
201703		54	-	-

[adityaakshaya]

Hi Mark,

you can explore rangesum function in this scenario.

Regards,

Akshaya

[sergio0592]

Hi,

You can use rangesum function. See my attached .qvw (i made a new sample because i'am in Personnal edition right now)

Regards

[Anonymous]

it is writting the sum in places that before there wasn´t any data.

in places where now there is now data, it should  be an acummulative sum and stop where there is now data.

[sunny_talwar]

May be this

If(Sum(V2) <> 0, RangeSum(Sum(V1), Sum(V2)), 0)

If(Sum(V3) <> 0, RangeSum(Sum(V1), Sum(V2), Sum(V3)), 0)