Show only data that meets a certain criteria
 

New to Pivot tables...I want my pivot table to only show the records where
the count of a field is greater than a set number. Any suggestions?

Show only data that meets a certain criteria
 

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