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