[Perc Total - Product categories - Part 2] How to compute a percentage of total in BigQuery using SQL #SQL #BigQuery

share_categories.sql

WITH
  revenue_product AS (
  SELECT
    product_category,
    ROUND(SUM(product_revenue),0) AS revenue_per_category
  FROM
    `datastic.variables.base_table`
  GROUP BY
    1)
  -- Main Query
SELECT
  *,
  SUM(revenue_per_category) OVER() AS total_revenue,
  SAFE_DIVIDE(revenue_per_category,SUM(revenue_per_category) OVER()) AS share_revenue
FROM
  revenue_product
ORDER BY
  share_revenue DESC