pivot chart YTD values from previous column

[stephenedberkg]

i want to show YTD (Rangesum) values in pivot chart based on previous column values.

i have attached the sample applications

I have data like below

	Year	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013
Product	Month	Jan	Feb	Mrz	Apr	Mai	Jun	Jul	Aug	Sep	Okt	Nov	Dez
P1		847	364	527	640	700	690	886	596	789	844	405	530
P2		643	1236	652	806	875	638	708	767	784	759	971	893

i want to show like that

Year	2013	2013	2013	201 !3	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013
Month	Jan	Jan YTD	Feb	Feb YTD	Mrz	Mrz YTD	Apr	Apr YTD	Mai	Mai YTD	Jun	Jun YTD	Jul	Jul YTD	Aug	Aug YTD	Sep	Sep YTD	Okt	Okt YTD	Nov	Nov YTD	Dez	Dez YTD
	847	847	364	1211	527	1738	640	2378	700	3078	690	3768	886	4654	596	5250	789	6039	844	6883	405	7288	530	7818
	643	643	1236	1879	652	2531	806	3337	875	4212	638	4850	708	5558	767	6325	784	7109	759	7868	971	8839	893	9732

[stephenedberkg]

Is it possible in qlikview???

stalwar1‌

[tresB · Accepted solution]

Like this (PFA)?