2 Replies Latest reply on Sep 20, 2018 3:25 AM by Tushar More

    Running sum after filters

    Yichuan Yu

      Hi, I have the below graph produced by using 'Running_sum' formula.

      It shows the accumulated number of members every month.

      In columns, there is Created_Date field, which is the date they joined as member.

      In rows, there is the running_sum of countd(profile_ID).

      image001.jpg

      However, when I applied filter for 2018 onward, the running_sum resets.

      My desired outcome is I only want to see the accumulated members from 2018 onward, which starts from 118k.

      image002.jpg

      Do let me know if you can think of any solutions, thanks!