Filtering a Pivot Field

Hello, without the sample file will be hard to help

Hi, I've attached an example of the table and a sample data table. Its the status that I'm trying to filter i.e. I just want it to count the ones that are open.