CUMULATIVE_SHARE

Family: Calculation context

Syntax

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

Arguments

Returns

A fraction from 0 to 1. It is null when the sum is zero.

Usage notes

• It is not one row’s share. For each row’s own share of a total, use SHARE_OF_TOTAL.
• Write OVER with ORDER BY after the call. With PARTITION BY, each group reaches 100 percent.

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
  CUMULATIVE_SHARE(orders.sum__quantity) OVER (ORDER BY orders.order_month) AS "Share So Far" /* @format percent(1) */
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, RUNNING_TOTAL, MOVING_AVERAGE, BY, ACROSS, IGNORE_FILTERS