Pivot: Filter parent row by child row results?

Is it possible to filter a pivot table such that a parent row is omitted upon the presence of a child value? In this example, we'd like to report on the customers only running older versions of a product.

Consider the following (simplified) data in which Customer1 only has old product, Customer2 only has new product, and Customer3 has both old and new product. We'd like to filter the data to only report on Customer 1.

Customer Version Ticket#
Customer1 old 1
Customer1 old 2
Customer1 old 3
Customer1 old 4
Customer2 new 5
Customer2 new 6
Customer2 new 7
Customer2 new 8
Customer3 old 9
Customer3 old 10
Customer3 new 11
Customer3 new 12

A simple pivot might appear as:
2019-03-14_14-26-04.jpg

OR

2019-03-14_13-14-02.jpg

Can I filter out any customers with New products?

Appreciate the help!

David

There's no direct way with standard Pivot Table.

Couple of methods.
1. Use DAX and PowerPivot (based on data model). DAX measure can be written to return null when Customer has New. Thus, filtering them out from Pivot Table.
Note: You can also use calculated column to use as filter flag in the model.

2. Add helper column in source table.
Ex: =COUNTIFS($A$2:$A$13,A2,$B$2:$B$13,"new")=0

Add it to your pivot's filter field, or use slicer.

0.JPG