% of Responders?

Content

Hello,

I am trying to build a summary chart of diversity statistics including % of responders.  An, example would be using the chart below.  Disibility candidate answers could be yes, no, or blank (non-responder).  I can easily get the percentage for all these responses as calculation of the percent of the sum.  But I can't get the % of responders (excluding the blank responses).  This chart shows what I get. The 2% under % Responders should be blank, and the sum should be 100%.  Does anybody know how to get this calculation to work?

Disibility	# Candidates	% Candidates	% Responders
No	9192	97%	99%
Yes	70	1%	1%
	176	2%	2%
Sum	9438	100%	102%

Thanks,
Dave