3 Replies Latest reply: Mar 27, 2018 12:26 PM by Digvijay Singh RSS

    Set Analysis - Measure sliding month from a dimension of the table

    Pierre-Yves POTIER

      Hello,


      I want to perform a setAnalysis that would be able to recover 3 months sliding (current month + 2 months previous) of a measurement according to the period dimensioned in the table.


      Example: In the example below, here are the CAs for each calendar period:

      Imagine the following data:

      Period   :  CA          :  CA 3 Months Slippery

      201803 :  14 280  :  96,081

      201802 :  37,634  :  91,801

      201801 :  44 167  :  59,167

      201712 :  10,000  :  etc ...

      201711 :    5,000

      Capture.PNG

       

      CA measurement: sum (ca)

      CA Measurement 3 Months Slippery:?


      Thank you in advance for your help !