Forum Discussion
Running Total with categories
Hi all, I have a question on running totals: I have a table "Data" of projects (identified by ID). Each project has a generated power "Power", an operational start year "Op_Year" (in number format -...
Anonymous thank you for the input.
Again not working, unfortuntely. The output is the one below:
If it may help, below the raw data I am using for this example (the real db is much more bigger and confidential, but the below is fully representative of the problem)
Spoiler
| ID | Power | Geo | Status | Op_Year |
| 1 | 10 | RoW | Installation | 2021 |
| 2 | 5 | RoW | Operational | 2019 |
| 3 | 4 | Europe | Design | 2021 |
| 4 | 7 | Asia | Operational | 1996 |
| 5 | 10 | Europe | Operational | 1993 |
| 6 | 3 | Americas | Installation | 2021 |
| 7 | 5 | Asia | Operational | 2000 |
| 8 | 3 | RoW | Operational | 1990 |
| 9 | 7 | Europe | Design | 2024 |
| 10 | 1 | Europe | Operational | 2006 |
| 11 | 1 | RoW | Design | 2025 |
| 12 | 4 | Asia | Operational | 1999 |
| 13 | 1 | RoW | Operational | 2016 |
| 14 | 6 | Asia | Installation | 2021 |
| 15 | 7 | RoW | Operational | 2015 |
| 16 | 6 | RoW | Operational | 2009 |
| 17 | 3 | RoW | Operational | 2016 |
| 18 | 3 | Europe | Operational | 1997 |
| 19 | 8 | RoW | Operational | 2001 |
| 20 | 4 | Europe | Operational | 1994 |
| 21 | 5 | RoW | Installation | 2022 |
| 22 | 2 | Europe | Operational | 2004 |
| 23 | 7 | RoW | Operational | 2012 |
| 24 | 1 | Americas | Operational | 2017 |
| 25 | 9 | Asia | Design | 2024 |
| 26 | 4 | Asia | Operational | 2018 |
| 27 | 2 | RoW | Installation | 2023 |
| 28 | 7 | RoW | Operational | 2015 |
| 29 | 5 | Asia | Operational | 2017 |
| 30 | 3 | Americas | Installation | 2020 |
| 31 | 4 | Europe | Design | 2028 |
| 32 | 6 | Asia | Operational | 2019 |
| 33 | 8 | RoW | Operational | 2017 |
| 34 | 10 | Europe | Operational | 1993 |
| 35 | 9 | Asia | Operational | 2017 |
| 36 | 5 | RoW | Design | 2023 |
| 37 | 9 | RoW | Operational | 2019 |
| 38 | 2 | Asia | Design | 2024 |
| 39 | 3 | Asia | Operational | 2013 |
| 40 | 3 | Asia | Operational | 2017 |
| 41 | 7 | Americas | Operational | 1997 |
| 42 | 6 | Americas | Design | 2027 |
| 43 | 5 | RoW | Operational | 2002 |
| 44 | 5 | Americas | Operational | 2018 |
| 45 | 8 | Americas | Design | 2022 |
| 46 | 6 | Europe | Operational | 2008 |
| 47 | 2 | RoW | Operational | 2015 |
| 48 | 4 | Americas | Operational | 2011 |
| 49 | 6 | Asia | Operational | 2017 |
| 50 | 7 | Asia | Operational | 2000 |
Can anyone help on this?
Thanks! 😊