Filtering out values on a crosstab without changing percentage values?

[cwright]

Please forgive my naivety; I am self taught.

I have a simple crosstab in which I have percentages for when a standard is met (text seen in screenshot) or not met (no). I want to only see the percentage of met, however when I filter out the no's it changes the percentage values. I am wondering if there is a way to filter out the "no's" without changing the percentage; for this example keep it saying 50% for each standard for test location.

Please let me know if I can explain this better. Thank you for any suggestions anyone may have.

You cannot view this attachment.You cannot view this attachment.