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;
<tbody>
</tbody>
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>