Courses / PivotTables & PivotCharts
24. Show Values As (Percent of Row/Column/Grand Total)
Changing a Values field to display as percentage of row, column, parent, or grand total instead of raw numbers.
Excel (PivotTables & PivotCharts)
Show Values As (Percent of Row/Column/Grand Total)
An option that displays a Values field as percentages of a chosen total (row, column, parent item, or grand total) instead of raw numbers.
"I want to show each sale as a share of its region, not just the dollar amount."
"Show Values As" replaces the raw value display in a PivotTable with a calculation that expresses each value as a percentage of a specified base: the row, column, parent item, or the grand total.
"I want to show each sale as a share of its region, not just the dollar amount."
"Show Values As" replaces the raw value display in a PivotTable with a calculation that expresses each value as a percentage of a specified base: the row, column, parent item, or the grand total.