在BigQuery中，可以使用窗口函数和累积（cumulative）函数来计算累积分布。下面是一个示例代码，演示如何在BigQuery中使用累积分布窗口函数：

WITH sales AS (
  SELECT 'A' AS product, 100 AS revenue UNION ALL
  SELECT 'A' AS product, 200 AS revenue UNION ALL
  SELECT 'B' AS product, 300 AS revenue UNION ALL
  SELECT 'B' AS product, 400 AS revenue UNION ALL
  SELECT 'C' AS product, 500 AS revenue
)

SELECT
  product,
  revenue,
  SUM(revenue) OVER (PARTITION BY product ORDER BY revenue) AS cumulative_revenue,
  SUM(revenue) OVER (PARTITION BY product) AS total_revenue
FROM
  sales
ORDER BY
  product,
  revenue

在这个示例中，我们创建了一个名为sales的临时表，其中包含产品和销售额数据。然后，我们使用窗口函数SUM(revenue) OVER (PARTITION BY product ORDER BY revenue)计算每个产品的累积销售额。该函数将revenue按照产品分组，并按照revenue的顺序进行累积求和。我们还使用窗口函数SUM(revenue) OVER (PARTITION BY product)计算每个产品的总销售额。

最后，我们按照产品和销售额的顺序对结果进行排序。

运行上述代码后，将得到以下结果：

product | revenue | cumulative_revenue | total_revenue
--------+---------+-------------------+---------------
A       | 100     | 100               | 300
A       | 200     | 300               | 300
B       | 300     | 300               | 700
B       | 400     | 700               | 700
C       | 500     | 500               | 500

这些结果显示了每个产品的销售额、累积销售额和总销售额。

希望这个示例能够帮助您在BigQuery中使用累积分布窗口函数。