Fields
The pivot table shown is based on three fields: City, Size, and Qty. The City field is added as a Row field, and the Size field is added as a Column field. The Qty field is is added as a Value field:
The Qty field in the Values area is configured to Sum:
By default the Pivot Table automatically sums values in the Qty field, so there is no need to change the calculation in this case.
Steps
Notes
Author
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
