We know that, PivotTable helps you to find the unique values from a wide data range. But the problem is to find the frequency of each unique value in that range
How to count the frequency of Unique values in PivotTable?
Assume that, You have Student and Marks column.
Now first step is to find the unique Student's name. To do this, drag the Student field in ROWS box in PivotTable.
This will show the unique students list. Now to find the frequency of each student, drag again the same Student field in COLUMNS box in PivotTable. This will count the students frequency:
Finally the result is as below:
How to count the frequency of Unique values in PivotTable?
Assume that, You have Student and Marks column.
Image 1: Students Table
Now first step is to find the unique Student's name. To do this, drag the Student field in ROWS box in PivotTable.
Image 2: Students Table in ROWS Box
This will show the unique students list. Now to find the frequency of each student, drag again the same Student field in COLUMNS box in PivotTable. This will count the students frequency:
Image 3: Count of Students
Finally the result is as below:
Image 4: Frequency of Unique Values