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?