Create a PivotTable Summary

Summarise rows of data by category in a few clicks.

You will learn to

• Choose a row field
• Choose a value field and aggregation

How it works

Select your data and choose Insert → PivotTable. Drag a field to Rows (for example Region) and a numeric field to Values (for example Revenue, summarised by Sum). PivotTables recalculate summaries without formulas.