Show / Hide items in Pivot Table as required

N

Nitesh

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 I’m 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting Date Range in a Pivot using VBA 0
Excel 2003 Pivot Table - deleted items still show in drop downs 1
VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected 0
Slicers and Calculated Items in Pivot Table 2
Get visible pivot table items 4
Show only Grand total in Pivot Table 0
Pivot table - eliminate rows out of the table 0
Hide all items in Pivot Field except specific items 1

Top