Summary  
This chapter explains how to apply comparative display transformations—such as percentage of grand total or percentage of row total—to aggregated data outputs without modifying the underlying calculations.  

General domain of usage  
Data reporting and analysis

Pivot Tables can display values in different ways without changing the underlying calculation. Instead of showing raw totals, you can display percentages, differences, rankings, or running totals. In this chapter, you'll use **Show Values As** to compare performance.

By default, Pivot Tables display values as standard aggregations: Sum, Count, Average.

However, you can change how those values are presented.



## Using "Show Values As"
To change how a value is displayed:
1. Click any numeric cell in the Pivot Table;
2. Open **Value Field Settings**;
3. Go to the **Show Data As** tab;
4. Choose a calculation type.

This does not change the original aggregation.
 It changes only how the result is displayed.

- Category A represents 35% of total revenue;
- Region North generates 28% of company revenue.

- Budget allocation;
- Resource planning;
- Strategic prioritization.

Used to analyze distribution inside a group.

- 60% of Electronics revenue comes from the North region;
- 45% of Furniture revenue comes from the South.

- Regional performance evaluation;
- Identifying dependency on specific markets.

Used to analyze category weight within each region.

- Electronics represent 40% of revenue in West;
- Clothing represents only 12% in East.

- Regional product strategy;
- Expansion decisions.

- Region South generates 15% less revenue than North;
- This quarter grew 8% compared to last quarter.

- Variance analysis;
- Trend monitoring;
- Management reporting.

Create a Pivot Table with:	
- Rows: Category;
- Columns: Region;	
- Values: Sum of Revenue.
	
Add Revenue again and set it to:<br>
% of Grand Total.
	
Add Revenue again and set it to:<br>
% of Row Total.

Master Excel Pivot Tables from the ground up: learn to prepare data, build insightful summaries, control data views, and unlock advanced analytical and interactive features for professional reporting.

Build confidence with clean data and basic Pivot Table creation, ensuring a solid foundation for advanced analysis.

Gain control over what data appears in your Pivot Table and how it is organized for clearer insights.

Unlock advanced analytical and interactive features to take your Pivot Table skills to the next level.

Calculation	Description	Example	Useful for
% of Grand Total	Used to measure contribution.	Category A represents 35% of total revenue; Region North generates 28% of company revenue.	Budget allocation; Resource planning; Strategic prioritization.
% of Row Total	Used to analyze distribution inside a group.	60% of Electronics revenue comes from the North region; 45% of Furniture revenue comes from the South.	Regional performance evaluation; Identifying dependency on specific markets.
% of Column Total	Used to analyze category weight within each region.	Electronics represent 40% of revenue in West; Clothing represents only 12% in East.	Regional product strategy; Expansion decisions.
Difference From / % Difference From	Used for performance comparison.	Region South generates 15% less revenue than North; This quarter grew 8% compared to last quarter.	Variance analysis; Trend monitoring; Management reporting.

Show Values As and Comparative Analysis

Using "Show Values As"

Common Comparative Calculations