Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cumulative sum per Year - Countdown

Hi everyone, 

 

I'm looking for a solution to create a calculation to sum the cumulative results Per Year for a countdown column.

Hereby an overview of (fake) numbers per Year by the Countdown column. The cumulative calculation needs to start by the highest number and needs to sum all the numbers till the lowest number in the column (WeeksUntil). As the column is a countdown.

Need Help

8 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    Anonymous Please share data in excel using onedrive/google drive to get your answer quickly. Remove any sensitive information before sharing.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi parry2k ,

       

      Hereby a link to a sample table stored in Google Drive.

       

      I've added the actual table and the requested cumulative sum per year.

       

      Would be great if you're able to help me!

       

      Thanks