Pivot Table - Filter Only Duplicates

[Robby19]

I have a Pivot Table showing a unique number, and then each person with that number. I want to be able to see only the duplicates of the unique number.

How do I filter the "Value" of a pivot table to show only numbers greater than 1?

For example, how do I remove BIC 410 since there is only 1;

BIC	LONG NAME	COUNT OF BIC
410 TOTAL		1
410	ABC	1
010 TOTAL		2
010	CDE	1
010	FGH	1

<tbody>
</tbody>

 

[Robby19]

Please disregard. Worked this out with a few If(And()) formulas and then used the Pivot Table filter off of that result.