Counting unique values in pivot table

In this lesson you will teach yourself how to do counting in pivot tables. Do you think it is difficult? You will be suprised.

1. Once the data is entered into Excel sheet, select the data then go to Insert -> Pivot Table. A dialog box will appear.

create insert pivot table

2. Select Existing sheet and enter the Location where you want to create the pivot table. Then check the add this value to the Data Model option and click ok.

existing worksheet

3. A pivot table field's pane will appear on the right. Then in the PivotTable Fields pane, drag the fields to lower boxes which are filter, column, rows, and sum of values as per your requirment. Then click the drop down list from Values, select Value Field Settings. A dialog will appear.

Value Field Settings Distinct Count

4. In this dialogue, select the tab Summarize Values By and scroll down. Then select Distinct Count. Then click ok. You will see a pivot table which will count only distinct values.

distinct count