Is there a way to create Running Total using Beast Mode?

lvtrujillot
lvtrujillot Manizales, COL ⚪️

Hi,

I'm building a table card and I would like to create a column that performs a cumulative sum, like the following:

| Week | Amount | Running Total

| 1 | 100 | 100 |

| 2 | 50 | 150 |

I tried to do this using SQL Dataflow, it works fine. However, I want to be able to add filters that modifies the Running Total and thus, the approach that I used with SQL doesn't help me much (since it performs the sum of the whole dataset row by row).

Any light on this would be much appreciated

Thanks

Best Answer

Answers