Forum Discussion

calloni's avatar
calloni
Icon for Helper I rankHelper I
2 years ago
Solved

Running total by year and quarter

Hello

I have the linked workbook that contains a very simple dataset and I need to be able to calculate the running total at end of each quarter of each year.

 

https://drive.google.com/file/d/1bTjLNuzJtAWQP111-X-7sq97_cCx8Vux/view?usp=sharing

 

So for example, for the total publications column I need a running sum like this:

 

Q1 = 43

Q2 = 105

Q3= 181

Q4 = 285

 

The original table is this one (if you are not able to open the linked workbook):

 

yearquartertotal_publicationstotal_downloads
2024143569957
2024262118133
2024376902038
20244104464008

 

Thanks in advance

Rodrigo

3 Replies

  • Thanks... I tried that and didn't work... anyway, now it does 😄

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User

      yes, these quick measures are very good suggestions but they don't always get it right.