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
I can walk on water when it freezes