Fields
The pivot table shown is based on three fields: Color, Size, and Qty. The Color field is configured as a Rows field, and the Size field is configured as a Columns field. The Color field is also configured as a Value field.
The Color field is configured to summarize by count in the Values area:
Because the colors are text values, the pivot table automatically performs a count instead of a sum. You are free to rename “Count of Color” 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.
