Pivot Table: Frequency Count by Another Column

Question

Data sample:

ColA | ColB

City1 | type1

City1 | type3

City2 | type2

City3 | type3

City3 | type2

I want to create a pivot table to count the number of type# by city#. I tried to throw ColA into Row Labels and Count of ColB into Values but I can't distinguish between type#. I'm missing something here.

If I were writing it in SQL: SELECT ColA, ColB, Count(ColB) FROM Sheet GROUP BY ColA, ColB

Answer 1

1. Put ColA as the row field, Col B as the column field, and Col B as the data field.
2. Put both ColA and ColB as row fields, and Col B as the data field.