Fields
The pivot table shown is based on two fields: Color and Amount. The Color field is configured as a row field, and the Amount field is a value field, as seen below:
The Amount field is configured to Sum:
You are free to rename “Sum of Name” as you like.
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.
