12 Replies Latest reply on Feb 14, 2020 3:55 AM by Zhouyi Zhang

    Get Running Sum of last 3 Periods. Please help!

    Patrick Dela Cruz

      Hello everyone,


      Objective is to get running sum of last 3 periods. I tried to used moving calculation to get the right values and it worked however with limitations.


      Moving calculation for the last 3 months does not work when I only filter 1 period. My goal is to make it fixed like when I filter one period which is FY20 P03, the equivalent value that will appear will be FY20 P01 + FY20 P02  + FY20 P03.