Summary and display of values

In a PivotTable, the summary chooses the calculation applied to values: sum, count, average, min, max. The Show Values As option presents them differently, for example as a percentage of the grand total, of the column total, or as a difference from a previous period. It does not change the source data.

Example

Switch "Sum of Montant" to "% of Column Total" to see each product's share.

Related concepts

The whole glossary