Pivot table percentages

[Pbspt]

I need help getting my pivot table to calculate a "percentage of". Here is what I need to do...my company requires staff to take a test and I need to be able to calculate the percentage of the total number of employees that have passed it.
My data set has the name, facility department, and test score of those passing (otherwise it is a blank cell). I can show the count of employee names and the count of those with a test score by department.
Rather than showing a count of test scores, i prefer to display a percentage that passed. Any help with this would be awesome.

 

[Jerry Sullivan]

Hi and Welcome to the Board,

Do you need to use a PivotTable for this?

It can be done with just worksheet formulas. Here is one example....

Excel Workbook
	A	B	C	D	E	F	G	H
1	Name	Department	Score		Results	# Employees	# Passed	% Passed
2	Name 01	Dept 1	87		Dept 1	5	3	60%
3	Name 02	Dept 1			Dept 2	5	4	80%
4	Name 03	Dept 1	91		Dept 3	5	5	100%
5	Name 04	Dept 1	90
6	Name 05	Dept 1
7	Name 06	Dept 2	86
8	Name 07	Dept 2	90
9	Name 08	Dept 2	95
10	Name 09	Dept 2	95
11	Name 10	Dept 2
12	Name 11	Dept 3	94
13	Name 12	Dept 3	90
14	Name 13	Dept 3	95
15	Name 14	Dept 3	91
16	Name 15	Dept 3	98
Sheet