Accumulation with two dimensions

[Dmichel0729]

Hello All, 

I currently have a line chart that displays a count accumulation throughout the years. The two dimensions I am using are Year and Month. However, when I drill down to a specific year, the accumulation starts over in January (see below). Is there anyway to make the continue the accumulation when a specific year is selected? 

Year Image:

Month Image (2020):

January for 2020 year selected should be close to the number 2499 in the first image. 

The expression I am currently using is count(Date) with Full Accumulation checked.

Any help would be appreciated. 

Thank you, 

Dylan 

[Dalton_Ruer]

You could modify your expression to something logically like this. (Notice I said logically don't copy paste this code)

IF (GetSelectedCount(Year) and RowNo() = 1, Sum(Set analysis to accumulate previous years values) + my value, Your rangeabove expression currently being used) 

[MayilVahanan]

Hi @Dmichel0729 

For ur scenario, you can use rolling n-period in scripting like below articles

https://community.qlik.com/t5/QlikView-Documents/Calculating-rolling-n-period-totals-averages-or-oth...

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130