PivotTable - Trying to return all entries not a 0 value

[ivenovember]

I have a data set, I simplified in the attached/below, essentially what I'm trying to do is create a PivotTable that someone could select certain countries and only return Companies that have a none 0 value for one of those countries. You can think of it as these Companies generating revenue in some of the countries and they should be returned if they generate revenue in any of the selected countries. For example, if China and Argentina were selected, it would should the entries for Company A, D and E but not the others.
No matter how i set up the data table, I'm running into the error that my filter to show non-0 values is only being applied to one of the Companies, not all of them.

Any help on the proper way to set this up? Thanks

pivottable.PNG

[stasinek]

Hello,
See if such a solution will be good (with an auxiliary column). You can also get rid of the auxiliary column using Power Query but do not know what version of Ex you have.