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?
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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks