Rows, Columns, Values, Filters areas

A PivotTable is built by placing fields in four areas: Rows and Columns for the categories that structure the table, Values for the data to summarize and Filters to limit the analysis to a subset. Moving a field from one area to another changes the angle of analysis.

Example

Rows: Produit; Columns: Année; Values: Sum of Montant; Filter: Région.

Related concepts

The whole glossary