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.