Dynamic Rolling Sum - 4 Quarters trailing

[Olip]

Hello Folks,

I have a requirement to compute rolling sum for the trailing quarters with a dynamic range from Current Quarter till the Last Quarter of the minimum Fiscal Year in the data set. For  an example, if the data set starts from '2013 Q 1' till '2018 Q 1' then the trailing quarters should be displayed from 2017 Q 4 till 2013 Q 4. Using a formula like '' works but does not take care the start and end of the  quarter:

'rangesum( above ( sum([Reported PEB]),0,4) )'

Any thoughts to achieve this. See below highlighted in green is desired and yellow highlighted is what I get now.

[sunny_talwar]

That is good to know, but is your data always coming in as Quarterly number? Would you be able to share few rows of raw data? Trying to make sense of what you might have

[JustinDallas]

Off-topic, but what does this statement mean?

Only({<FQ>} FQNum) >= Min({1}TOTAL  FQNum, 4)

I think it means "If there is one FQNum selected, regardless of the FQ,

                           and that value is greater or equal to

                           the least of the 4 FQNums of the entire dataset regardless of selection,

                           then...

[sunny_talwar]

If there is one FQNum selected

Doesn't have to be selected.... FQ and FQNum are one to one and that is why I used Only().... it doesn't mean that one FQNum is selected