Forum Discussion
calloni
Helper I
2 years agoRunning 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):
| year | quarter | total_publications | total_downloads |
| 2024 | 1 | 43 | 569957 |
| 2024 | 2 | 62 | 118133 |
| 2024 | 3 | 76 | 902038 |
| 2024 | 4 | 104 | 464008 |
Thanks in advance
Rodrigo
(true, this needs a little love:)