Hiding items in Pivot Table

[ackman71]

Is there anyway to quickly choose to hide all items on a pivot table and then jsut click the one's you want to include instead of picking the ones you want to hide. I have a database with maybe 4000 employees on it. Sometimes i might want to have the pivot table to show only 50 of them. To do so I would have to click on 3950 to hide instead of clicking on 50 that I want to show. The ctr-a does not seem to highlight them all to hide.

 

[Mark W.]

Book1
	A	B	C	D	E	F	G
1	Name	Value	Selector		Selector	1
2	Jeri	10	1
3	Mary	20	0		SumofValue
4	Larry	30	1		Name	Total
5	Barry	40	0		Gary	60
6	Harry	50	1		Harry	50
7	Gary	60	1		Jeri	10
8					Larry	30
9					GrandTotal	150
10
Sheet2