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

[supportlahaye]

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

CA measurement: sum (ca)

CA Measurement 3 Months Slippery:?

Thank you in advance for your help !

[Digvijay_Singh]

Maybe this -

Rangesum(Below(Sum(CA),0,3))

[supportlahaye]

It Works !

I use the Rangeavg in my case in the end.

Thank You so much !

[Digvijay_Singh]

Great! You may close this thread by marking correct answer.