Fields
The pivot table shown is based on three fields: Color, Size, and Qty.
The Color field is also configured as a Value field.
You are free torename"Count of Color" as you like.
Steps
Notes
Pivot table two-way count
Pivot tables are an easy way to quickly count unique values in a data set, and can easily be adapted to perform a two-way count.
