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.

       

       

      Thanks,

      Pat