Filtering a Pivot Field

I have a pivot table whereby one of the fields had selectable options in the data range (open, closed, deferred). In the pivot table I only want to show the data from one option (e.g. closed). I've changed the option in the filter and recalculated but the data is unchanged. What am I doing wrong?

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.

Thats actually a very good point. I've been trying to filter at the table level without the use of slicers but I suspect the slicer will work just as well. I'll give it a go.

You can even put the 'status' field in filters window of pivot table even that would filter your data according to the 'status' you choose.

Yeah slicers are great!