A pivot’s percentage display expresses a measure relative to a chosen whole. Decide whether that whole is a row, column, or grand total before formatting the output.
Verify the base measure
First check the pivot in its ordinary numeric display. Confirm the source range, aggregation, filters, and units. A percentage derived from an incorrect sum remains incorrect.
Distinguish amounts from rates already stored in the source. Summing individual percentages is not automatically a meaningful overall rate, particularly when the underlying denominators differ.
Choose Show as deliberately
Open the pivot editor. Under Values, inspect Show as and choose the required percentage option. Use the available row, column, or grand-total interpretation that matches the reporting question.
Changing a cell’s number format to Percentage alone is different: it does not calculate a share of the pivot total. Check the actual value and the selected Show as behavior.
Reconcile the denominator
For a small example with group amounts 20 and 80 and a grand total of 100, their grand-total shares should be 20% and 80%. Test a filtered case and verify which population defines the new denominator.
Label the percentage clearly so readers know what it is a share of. Include enough base values to explain the result, and handle zero denominators explicitly. A filtered report can show percentages of the filtered population rather than the organization’s full total. Verify totals and rounding before export, and avoid interpreting a tidy 100% sum as proof that missing source categories were included or that the measure itself was appropriate.
References
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.