Pivot Table Calculation Field (Countif)

[BensTooCool]

Hi All,

I have a pivot table with data, one column captures text (Open, Closed) entries. I want to create a calculated field that will do a count of closed.

I know I could just drop the field into Column as well as rows to filter this way but my pivot tables contains a number of other columns and it messes up my data. So I don't want anything in the Column labels. Hope that makes sense.

I've done a some searching but I've not found anything that covers my scenario, anyone got a solution?

Thanks,

Ben