Show only data that meets a certain criteria

B

Bob

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?
 
S

steven1001

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 DisplayIf>2
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
 
Top