Calculation Option

PivotShowValuesAsType Member

Description

% of Grand Total 
PivotShowValuesAsType.PercentOfTotal 
Displays values as the percentage of the grand total of all values in the PivotTable report. 
% of Column Total 
PivotShowValuesAsType.PercentOfColumn 
Displays values in each column as the percentage of the total value of the column. 
% of Row Total 
PivotShowValuesAsType.PercentOfRow 
Displays values in each row as the percentage of the total value of the row. 
% of Parent Column Total 
PivotShowValuesAsType.PercentOfParentColumn 
Displays values in each inner column as the percentage of the total of the parent item in the outer column. 
% of Parent Row Total 
PivotShowValuesAsType.PercentOfParentRow 
Displays values in each inner row as the percentage of the total of the parent item in the outer row. 
Index 
PivotShowValuesAsType.Index 
Calculates the relative importance of each summary value by using the following formula:
((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total)) 
% of Parent Total 
PivotShowValuesAsType.PercentOfParent 
Displays values in a data field as the percentage of the value of the parent item in the specified base field. 
Rank Smallest to Largest 
PivotShowValuesAsType.RankAscending 
Displays the rank of values for a specific base field, listing the smallest item in the field as 1, and each larger value with a higher rank value. 
Rank Largest to Smallest 
PivotShowValuesAsType.RankDescending 
Displays the rank of values for a specific base field, listing the largest item in the field as 1, and each smaller value with a higher rank value. 
Running Total In 
PivotShowValuesAsType.RunningTotal 
Displays values for successive items in the base field as a running total. 
% Running Total In 
PivotShowValuesAsType.PercentOfRunningTotal 
Calculates a running total for successive items in the base field as a percentage of the grand total value. 
% Of 
PivotShowValuesAsType.Percent 
Displays values as the percentage of the value of the base item in the base field. 
Difference From 
PivotShowValuesAsType.Difference 
Displays values as the difference from the value of the base item in the base field. 
% Difference From 
PivotShowValuesAsType.PercentDifference 
Displays values as the percentage difference of the value of the base item in the base field. 