Hi! I’m stuck finding the best way to have a column in a table that sums the accumulated revenue every month:

Any ideas?

Hi! I’m stuck finding the best way to have a column in a table that sums the accumulated revenue every month:

Any ideas?

Especially:

Also:

There are many ways to skin this cat, but the one I offered is:

- Create a column called
*OrderId*with formula:

```
thisTable.Find(thisRow)
```

- Then your
*Accum. Revenue*formula can be:

```
thisTable.Filter(OrderId <= thisRow.OrderId).Revenue.Sum()
```

2 Likes