Fields

The pivot table shown is based on three fields: Age, Gender, and Rating. The Age field is added as a Row field, and the Gender field is added as a Column field. The Rating field is is added as a Value field:

The Rating field in the Values area is renamed to “Avg Rating” and configured to Average:

The custom name can be anything except an existing source field names (i.e. “Age”, “Gender”,“Rating”).

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.   

Pivot table two way average - 63Pivot table two way average - 75