Pivot tables make it easy to count values in a data set.

One way this feature can be used is to display duplicates.

Fields

The data contains 263 rows, each with a City and Country.

Pivot table show duplicates - field list

Pivot table show duplicates - field list

Pivot table show duplicates - field list

Pivot table show duplicates - field list

Pivot table show duplicates - field list

Pivot table show duplicates - value field settings

Pivot table show duplicates - city filter

Pivot table show duplicates - city sort