Show / Hide items in Pivot Table as required
 

Hi

I am using MS Excel 2003 and need a macro code for show only my selected
items only in a Pivot Table.

Query:

One excel table empstatus.xls in which fields are Employee No , Department,
Status, other fields. In status field items are Blank, Leave, Left, Resigned.
I wanted to show only blank & leave based on when Im selecting a particular
month in my pivot table.
So is there any code to hide all data items of status and only show blank &
leave.

Please suggest.




--
------------------------------
Thanks
Nitesh
------------------------------