Calculations Updated November 2026

Percent of row and column total

In a pivot with both Rows and Columns, right-click a value and choose Show Values As, % of Row Total to make each row add to 100% (the mix inside each row), or % of Column Total to make each column add to 100% (where each column's total comes from).

Syntax

Right-click a value > Show Values As > % of Row Total | % of Column Total

Part	What it is
`% of Row Total`	Cell divided by its row's Grand Total; rows sum to 100%
`% of Column Total`	Cell divided by its column's Grand Total; columns sum to 100%
`% of Parent Row / Column Total`	Base is the subtotal of the enclosing group rather than the whole row or column

Examples

Rows: Region. Columns: Product. Values: Sum of Units (% of Row Total)

Result: For each region, what share of its units each product makes up; every region row ends in 100%.

Rows: Region. Columns: Channel. Values: Sum of Revenue (% of Column Total)

Result: For each channel, how its revenue splits across regions; every channel column ends in 100%.

Rows: Department, Level. Values: Count of Employee ID (% of Parent Row Total)

Result: Each level as a share of its department's headcount.

Common mistakes

The Grand Total column shows 100% on every row and that looks wrong: it is correct for % of Row Total; the row total is the base.
You picked % of Row Total but wanted the column mix: swap to % of Column Total, the names refer to which total is the base.
Percentages show #DIV/0 style blanks: an empty row or column total has no base; filter out empty items.

Practice Percent of row and column total

These drills check your answer on live data, free, no account needed.

Product mix inside each regionWith Region in rows and Product in columns, show what percentage of each region's revenue comes from each product.
Where each channel sellsWith Country in rows and Channel in columns, show what percentage of each channel's Sales comes from each country.

Questions

Which should I use, % of row or % of column?

Ask which direction should add to 100. Product mix within each region is % of Row Total (regions in rows). Regional split of each channel is % of Column Total (channels in columns).

Can I show % of row total in Google Sheets?

Yes. In the pivot editor, under Values, set Show as to % of row or % of column.

Percent of grand totalShow each row as a share of the overall total with Show Values As, % of Grand Total. Add it next to the raw numbers, format it, compare with parent totals.
Difference from previousCompare periods inside a pivot table with Show Values As, Difference From and % Difference From. Pick the base field and (previous); why period one is blank.
Rows, Columns, Values and FiltersThe four pivot table areas: Rows make the row labels, Columns spread categories across the top, Values hold the numbers, Filters restrict the whole table.