7 Replies Latest reply: Jun 19, 2017 11:19 AM by Sunny Talwar RSS

    Rolling 3 months problem when crossing YEAR

    Глеб Aitov

      Hi

       

      This is common question here, I tried the solution discussed here, but it didn't work.

       

      When single YEAR is selected, say 2017, previous year sales are not included in rolling sales.

       

      I use the following formula to compute rolling sum of sales for last 3 months:

       

      rangesum(

      above(

        aggr(

        Sum( {< [Month]=,[Year]=>} Sales),

           [Month] ),0,3)  )

       

      It does not work.

       

      Any idea?

      Thank you!

       

      Screenshot_60.jpg