Pivot table count of students (counts same many times)

[drom]

Hi and thanks in advance!

I have a table with many rows
This table shows Students names School, Subjects, Initial mark, Final Mark, Attendance...
Obviously a student has many subjects
So When I am showing a pivot table (See attached) my Count of Students shows many more students than the real ones because I am summing the same student many times
So if a student named eg Peter has 5 Subjects My Count of students In my Pivot table will show 6 for him, not just 1 when I am summarizing by School

ps: I now how to add a new column and put 1 or 0 when necessary
I am trying to learn if there is any other way?

	My Table, just for this eg: (can contain many rows)
	Student	Subject1	SubSubject	Initial Mark	Final Mark	School
	PETER	Maths	Exercices	6,5	6,5	XXX
	PETER	Maths	Exercices	4	4	XXX
	PETER	Maths	Aptitude	6,5	6,5	YYY
	PETER	Maths	Aptitude	6,5	6,5	XXX
	PETER	Maths	Learning	4	6,5	XXX
	PETER	Music	Learning	7,4	7,55	XXX
	PETER	Music	Cooperation	6,5	7,25	XXX
	Mike	Spanish	Cooperation	6,5	6,5	XXX
		This is my Pivot table for this eg			I would like to see 2 stead of 7
		Row Labels	Average of Initial Mark	Average of Final Mark	Count of Student
		XXX	5,91	6,40	7
		YYY	6,50	6,50	1
		Grand Total	5,99	6,41	8

 

[denzo36]

If using Excel 2016 and onwards if you check the 'Add this data to the Data Model' when creating the Pivot Table you can do a distinct count of student rather than count of rows

So if you add your Student to the values field in the pivot table, it will count all rows. If you then right click on this field in the pivot table and go to Value Field Settings then go to the bottom of the list and select Distinct Count as per below it will give the desired result