Share
Explore
Raw Data
0
Month
Revenue
Accum. Revenue
OrderId
Should be...
1
Jan 1
$1,000.00
$1,000.00
1
$1,000.00
2
Feb 1
$1,000.00
$2,000.00
2
$2,000.00
3
Mar 1
$1,000.00
$3,000.00
3
$3,000.00
There are no rows in this table

Problem
: I want to have a column with the accumulated revenue per month. For example in February it should be $2,000 and March $3,000.


Solution


Create a “OrderId” column.
Create a new column with the formula: thisTable.Filter(OrderId <= thisRow.OrderId).Revenue.Sum()
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.