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.




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.   

Pivot table two way sum - 14Pivot table two way sum - 13