need to add cumulative dates for pivot table

[Ramya]

Hi Guys,

I am new to qlikview.

i unable to achieve the requirement below.

i need to get the below eid event for 2020 year. but it is coming under 2019 in the below attached pivot table.

and also i need to get the cumulative numbers for months instead of names like jan as 1, feb as 2 and so on and for 2020 jan i need to get 13 and feb 2020 as 14. 

below is the sample data.

Regoin	sub region	stardate	end date	event
ams	us	3/1/2019	4/2/2019	diwali
ams	ca
ams	cp
ams	cr	6/10/2019	7/8/2019	function
ams	br
ams	hy
ams	cc
ams	ff
emea	hh	1/12/2020	2/14/2020	eid
emea	uu	9/12/2019	10/14/2019	bakdrid
emea	ff
apj	ee	11/4/2019	12/6/2019	newyear
apj	ind
apj	mys
apj	japn	1/3/2019	2/15/2019	christmas

i need to get as below. in the pivot table

	year	2019	2020
quater	Q1	Q2	Q3	Q4
Regoin	Month	Jan	Feb	Mar	Apr	Jun	Jul	Sep	Oct	Nov	Dec	jan	feb	march
		1	2	3	4	? Where is may	7	9	10	11	12	13	14	15
ams		-	-	diwali	diwali	function	function	-	-	-	-
apj		christmas	christmas	-	-	-	-	-	-	newyear	newyear	eid	eid
emea		-	-	-	-	-	-	bakdrid	bakdrid	-	-

Can any one please help me to achieve this.

[Frank_Hartmann · Accepted solution]

see attached (with cumulative value for month!)

[Ramya]

Thank you so much Frank.

[Frank_Hartmann]

please close this thread by marking the correct answer!