Forum Discussion

amirghaderi's avatar
amirghaderi
Helper IV
5 years ago
Solved

Moving Sum

Hi, I am looking for moving 3 weeks sum measure for a column value. Example as below: Can anybody help?   Record Date EV Moving Sum RESULT A 2/04/2021 1000 A 1000...
Need Help
  • Tahreem24's avatar
    Tahreem24
    5 years ago

    amirghaderi  as per the informtation provided and data attached in very first post I used that and generated the expected result. See the screen shot below:

     

Tahreem24's avatar
Tahreem24
Super User
5 years ago

amirghaderi  as per the informtation provided and data attached in very first post I used that and generated the expected result. See the screen shot below:

 

amirghaderi's avatar
amirghaderi
Helper IV
5 years ago

Thanks, It worked. I only chnaged the filter to Allselected to make sure the filter applied to the report works on measure as well.