How to findout YTD Measure

[Former Member]

Customer	Fiscalperiod	COUNTRY	Seqnumber	Measure
C1	201301	A	1	3
C2	201302	A	2	2
C3	201303	A	3	3
C4	201304	A	4	4
C5	201305	A	5	5
C6	201306	A	6	6
C7	201307	B	7	7
C8	201308	B	8	8
C9	201309	B	9	9
C10	201310	B	10	10
C11	201311	B	11	11
C12	201312	B	12	12
C1	201401	A	13	1
C2	201402	A	14	2
C3	201403	A	15	3
C4	201404	A	16	4
C5	201405	A	17	5
C6	201406	B	18	6
C7	201407	B	19	7
C8	201408	B	20	8
C9	201409	B	21	9
C10	201410	B	22	10
C11	201411	B	23	11
C12	201412	B	24	12

Hi Friends, I am working on HANA

I am loading above  flat file to Hana studio through graphical calculation view

My requirement:

if user selects Fiscal period '201404'

Out put   required look like given below

COUNTRY	CURRENT MONTH   'Measure'	YTD 'Measure'	Previous year   month 'Measure'	Previous year   YTD 'Measure'
A	4	10	4	12

YTD is year to date

I am trying hard for it but I am unable to get the answer. I gone through scn website and other articles regarding YTD but I dont get  any clue on my requirement.  Please give me solutions for this, answers will be rewarded.

Thank you in advance

[Former Member]

everything I need to calculate through graphical only

[srinivasan_vinayagam]

Hi Karun,

follow this links may you get solutions.

Regards,

V Srinivasan

[Former Member]

Thanks srinivas I alredy gone through those documents

Here I am facing problem with data type for financialperiod loading throgh flat file, Icant take data type as DATE.