'Excel pivot table shows only when rows have multiple other types of rows corresponding to a row label
I would like to use pivot table to show only rows which have another type of rows more than two rows.

Over here, first (4 rows) and third (2 rows) row labels have more than two another rows. I would like to filter out if there is only one such as the second and the last one in this picture.
Like this.

There are more than 4,000 rows, so I cannot do it manually like I just did (just selected only two )
Is there any way that I can do it automatically to deal with large data?
I have tried to it with labels filter but nothing seems to be related.

Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
