RUNNING_TOTAL

Family: Calculation context

Syntax

1
RUNNING_TOTAL(value) OVER ([PARTITION BY ...] ORDER BY ...)

Arguments

Returns

The sum from the first row through this row.

Usage notes

• Write OVER with ORDER BY after the call. PARTITION BY starts the sum again for each group.
• It counts rows, not calendar periods. A month with no rows is not in the result, so the sum steps over it.
• Order by a field that gives each row one place, so the sum is the same on each run.

Example

This Sandbox query reads the sample shop’s orders. The table shows the rows that Kater gave.

1
SELECT
2
  orders.order_month AS "Order Month",
3
  EVAL(orders.sum__quantity) AS "Units",
4
  RUNNING_TOTAL(orders.sum__quantity) OVER (ORDER BY orders.order_month) AS "Running Units"
5
FROM kater_dataset.orders AS orders
6
WHERE
7
  KATER__IS_ON_OR_AFTER(orders.order_date, DATE '2026-05-01')
8
GROUP BY
9
  orders.order_month
10
ORDER BY
11
  1

See also

• Change a measure’s context
• Other functions in Calculation context: TOTAL, SHARE_OF_TOTAL, VALUE_FOR, CALCULATE_ACROSS, CALCULATE_BY, CALCULATE_PER, RATIO, MOVING_AVERAGE, CUMULATIVE_SHARE, BY, ACROSS, IGNORE_FILTERS