12 Replies Latest reply: Jan 17, 2018 3:50 PM by Sunny Talwar RSS

    Dynamic Rolling Sum - 4 Quarters trailing

    Alip Nath

      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.

      Trailing Quarter.JPG