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.

[MDXpressor]

My initial reaction to this is to apply the filter AFTER auto-aggregation.  In the property pane of the filter, you should see a property for Application, and it defaults to before auto-aggregation.  The short description of this is before auto-aggregation filters out any records at the database.  After auto-aggregation, allows all the records into the query, and then filters the results of the calculation.  My screen shot shows the example, and Cognos' more robust description of the Application proptery's impact.