LAST YEAR CUMULATIVE

[sagaraperera]

Dear all

Please  note I have obtain  the value of the last year month and the value of current year cumulative. Kindly advise me whether their is a method for an example by amalgamating the

Last Year Month =    sum( {$<TRAN_YEAR = {"$(=Only([TRAN_YEAR]-1))"}>} [Actual])

Current Year Cumulative =    sum( {<TRAN_MONTH={"<=$(=max(TRAN_MONTH))"}>} Actual)

and arrive at LAST YEAR CUMULATIVE

Sagara

[Chanty4u]

hi,

https://community.qlik.com/docs/DOC-9162

hope this helps u

[tresB]

Which time span are you interested of ?

[#4]

Try this link:

cumulative calulation for last year

[Chanty4u]

sum( {$<TRAN_YEAR = {"$(=Max(Year([TRAN_YEAR]))-1)"}>} [Actual])