Filter Pivot Table Data

[jdillberg]

Hello,
I have a pivot table with the phone numbers of customers and the count of times that we went to visit these customers. What I'd like to do in my pivot table is to display only the counts greater than one. I've tried almost everything so far, but can't come up with a solution.
For example

Client # SumVisits
123 2
234 1
563 1

 

[Craig92604]

If you drop the client # and the SumVisits in the Row field and the SumVisits in the data field you can display as you stated.

 

[jdillberg]

Thanks! The table looks a bit weird, but I only needed to filter out these values.

 

[Mark W.]

Why don't you simply filter the source data used by the PivotTable.