making an accumulation for a specific interval Help in expression
Hello I have the following data:
grouped by Month Year under the first column I have the actual values based on my selection of fiscal year 2023 and thus I have data from 202210 till 202304 (fiscal year starts on October): Sum({<MonthDiff={0},Scenario={Actual},Date_Num={"<$(=Max({1<[Is Current Month]={1}>}Date_Num))"}>}Periodic)
in the second column I have the previous value next to each current value by month rangesum(above( Sum( {<[Fiscal Year],[Calendar Year], [Year Month]=, MonthDiff={0},Scenario={Actual}>}Periodic )))
the third column has the difference using the following expression rangesum ( Sum({<MonthDiff={0},Scenario={Actual},Date_Num={"<$(=Max({1<[Is Current Month]={1}>}Date_Num))"}>}Periodic), -1*above( Sum( {<[Fiscal Year],[Calendar Year], [Year Month]=, MonthDiff={0},Scenario={Actual}>}Periodic ) ))
Now what I want is make an accumulation starting from 202210 till 202304
182 then 182 + 27, 182+27+4 , etc... I tried to add an additional rangesum on top but I'm getting accumulation from the very start kindly advise