FORMULA & SQL / TOTALS

Each row as a percent of its group.
Tested, not guessed.

The Excel and Google Sheets formula and the SQL query, each run on the rows below. Open this with your own data ↗

The example rows

Row	A: Region	B: Rep	C: Amount	D: Order Date	E: Status	F: Customer
2	North	Ana	1,200	2026-03-01	Paid	Jo Smith
3	South	Ben	450	2026-03-15	Open	Raj Patel
4	North	Cy	300	2026-04-02	Paid	Lee Wong
5	East	Ana	980.50	2026-04-20	Paid	Mia Ross
6	North	Ben	75	2026-05-05	Open	Jo Smith
7	West	Dee	1,640	2026-05-18	Paid	Sam Okoro

Excel

=C2/SUMIFS(C:C,A:A,A2)

Amount (C2) divided by the total of the Amount column (C:C) where the Region column (A:A) is Region (A2).

Format the column as a percentage.

Run on the example rows:

PostgreSQL

SELECT *, ROUND(100.0 * amount / SUM(amount) OVER (PARTITION BY region), 2) AS percent_of_group
FROM sales

Run on the example rows:

region	rep	amount	order_date	status	customer	percent_of_group
East	Ana	980.5	2026-04-20	Paid	Mia Ross	100
North	Ana	1200	2026-03-01	Paid	Jo Smith	76.19
North	Cy	300	2026-04-02	Paid	Lee Wong	19.05
North	Ben	75	2026-05-05	Open	Jo Smith	4.76
South	Ben	450	2026-03-15	Open	Raj Patel	100
West	Dee	1640	2026-05-18	Paid	Sam Okoro	100

Other databases

MySQL

SELECT *, ROUND(100.0 * amount / SUM(amount) OVER (PARTITION BY region), 2) AS percent_of_group
FROM sales

SQL Server

SELECT *, ROUND(100.0 * amount / SUM(amount) OVER (PARTITION BY region), 2) AS percent_of_group
FROM sales

SQLite

SELECT *, ROUND(100.0 * amount / SUM(amount) OVER (PARTITION BY region), 2) AS percent_of_group
FROM sales

BigQuery

SELECT *, ROUND(100.0 * amount / SUM(amount) OVER (PARTITION BY region), 2) AS percent_of_group
FROM sales

Snowflake

SELECT *, ROUND(100.0 * amount / SUM(amount) OVER (PARTITION BY region), 2) AS percent_of_group
FROM sales

Paste your rows into the free tool and it writes this for your columns, then runs it on your data before you copy it. Open the tool ↗