Calculate a running total

sql

SELECT
  order_date,
  daily_revenue,
  SUM(daily_revenue) OVER (ORDER BY order_date) AS running_revenue
FROM daily_order_metrics;

Explanation

Window functions let you keep row-level detail while adding cumulative calculations.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing window functions

Rank a user's orders by recency.

Open In sheetsqlsame section

Calculate day-over-day change.

Open In sheetsqlsame section

Rank categories by revenue without gaps.

Open In sheetsqlsame section

Return the total number of rows in a table.

Count orders by status.

Calculate totals and averages.