By default, a Pivot Table will countall recordsin a data set.

In the example shown, the pivot table displays how many unique colors are sold in each state.

Fields

The pivot table shown is based on two fields: State and Color.

Pivot table unique count field configuration

This is what makes the distinct count option available.

Steps

Notes

Pivot table unique count field configuration

Pivot table unique count field configuration

Pivot table unique count field configuration

Pivot table unique count field configuration

Pivot table unique count value field settings

Pivot table unique count add to data model