You could create some 'helper' columns and use 'countif' to find the
number of instances then set a label value based on some formula such
as =if([CountIf]2,"Display","hide")
Then put that label in the page section of the PT and select "display".


type Countif DisplayIf2
A1 7 Display
A1 7 Display
A1 7 Display
A1 7 Display
A1 7 Display
A1 7 Display
A1 7 Display
B1 3 Display
B1 3 Display
B1 3 Display
B4 1 hide
B5 1 hide
B6 1 hide


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=555026