Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
matapp80
Contributor
Contributor

Cumultive sum considering two months ahead

Hi community,

I would like to understand how to make the cumultive sum considering two months ahead (as shown in the figure, column "Inc di compentenza entro 60gg"). Dimensions are YearMonth and Project. Any idea how to obtain that? thx!!!

 

YearMonthProjectSALLIncassato Inc di compentenza entro 60gg  Inc di compentenza entro 30gg 
20161117039970,000,00 0,000,0% 0,000,0%
20161217039970,000,00 0,000,0% 0,000,0%
20170217039970,000,00 0,000,0% 0,000,0%
20170317039970,000,00 3.000,000,0% 0,000,0%
20170417039970,000,00 7.000,000,0% 3.000,000,0%
201705170399711.820,003.000,00 9.000,0076,1% 7.000,0059,2%
20170617039970,004.000,00 9.000,000,0% 9.000,000,0%
20170717039970,002.000,00 9.000,000,0% 9.000,000,0%
20170817039970,000,00 10.000,000,0% 9.000,000,0%
20170917039970,000,00 10.000,000,0% 10.000,000,0%
20171017039970,001.000,00 10.000,000,0% 10.000,000,0%
20171117039970,000,00 10.000,000,0% 10.000,000,0%
20171217039970,000,00 10.000,000,0% 10.000,000,0%
20180217039970,000,00 10.000,000,0% 10.000,000,0%
20180317039970,000,00 10.000,000,0% 10.000,000,0%
20180417039970,000,00 10.000,000,0% 10.000,000,0%
20180517039970,000,00 10.000,000,0% 10.000,000,0%

 

Labels (3)
2 Replies
Edvin
Creator
Creator

Try:

=sum(aggr(rangesum(below(sum([Incassato]),2,1)),[Project])

matapp80
Contributor
Contributor
Author

it doesn't work... 😞