Pivot Table in Excel - Percentages and Values

A pivot table is a statistics tool that summarizes and reorganizes selected columns and rows of data in a spreadsheet or database table to obtain a desired report. The tool does not actually change the spreadsheet or database itself, it simply “pivots” or turns the data to view it from different perspectives.

The Value Field Settings dialog box in a PivotTable allows users to change the calculation and display settings for data fields. The dialog box has two tabs: Summarize Values By and Show Values As.

The Summarize Values By tab has 11 calculation options, including Sum, Count, Average, Max, Min, Product, Count Numbers, StdDev, StdDevP, Var, and VarP. By default, numeric value fields use the Sum function, while text values use the Count function.

With the custom calculations available in the Show Values As settings, you can make a pivot table easier to understand at a glance. These settings are especially helpful if the original data has large numbers. The Show Values As tab has 15 options, including: No Calculation, % of Grand Total, % of Column Total, and % of Row Total.

% Of Grand Total
% of Column Total
% of Row Total
% Of
% Of Region
% Of Item
% of Parent
% of Parent Row Total
% of Parent Column Total
% of Parent Total
Difference From
% Difference from
Running Total in
% Running Total In
Rank

#custom #summarize #analyze #explore #present #calculation #Sum #Count #Average #Max #Min #Product #Count Numbers #StdDev #StdDevP #Var #VarP #numeric #fields #function #Show #Values #Grand #Grand Total #Column Total #Row Total #Running Total #Rank #Parent #Difference