I have a pivot table, see below. How can I filter this pivot table to where Sum of Not Compliant is not 0. I cannot add filters to any of the Sum columns in this take. The final column in this pivot table is a calculated field that I added to show the percentage of Non-Compliant.
I thought it would be easy to add a filter to the pivot table and just filter to where the sum of non compliant is non-zero. However, excel does not allow this. I also tried to filter to where the calculated field was greater than zero. However, excel did not allow this either. Not sure what to do. This is excel related, please approve question.