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.
Screenshot 2024-12-11 094009.pngScreenshot 2024-12-11 094418.png
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.