Hide Data at a Certain Matrix Table Level

Hello,

I have a table with 1 lvl of drilldown, eg:

Customer                   Value                    Sale Type

A                                 100                       xxxx

--> order 1                 40                         New

--> order 2                 60                         Upsell

B                                 200                       xxxx

--> order 1                 140                        New

--> order 2                 60                         Upsell

I would like the result under Sale Type at the customer level to be nil. Currently, I only have the 'first' or 'last' option, meaning Sale Type against customer A would be either New or Upsell, but really it's a mix so I just want it to be blank.

The following link looked to be inthe right direction, but I think this only works for values?

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

Many thanks,

Mike